Software Testing

1. Query for top 5 emps from 10 dept tables 2. Purpose of Alias and duplicate tables, how do use them, explain them with a scenario 3. What is Usage Tracking and how do we implement that 4. Implicit Fact Tables 5. You have 4 Dimensions how will you create a Pivot Table View 6. Pre-requisites for OBIEE Installation 7. How do you implement Snowflake Schema in your RPD 8. What is the toughest issue which you face during your Answers development ?  ANS:  While preparing a simple report with 2 dims & 1 Fct, data is not populated in a column, reason is there is a (chr32) in one  of the dimension values and we have used the same as filter in the report 9. How do you improve performance of OBIEE 10. A user should not able to view a particular table / column while preparing answers 11. In a snow flake schema a Dimension Table D1 is mapped to D2 and inturn Dimension D2 is mapped to Fact F1, in this case how can you show your report with D1 & F1 data ...

1) How do you debug COREDUMP, in weblogic 2) How do you identify duplicate values in a table 3) Explain Reveleus Services, Architecture, Modules and functionality 4) How do you apply patches on Reveleus ? 5) What are the commands you use in UNIX while installing Reveleus 6) What are the Oracle SQL functions do you use daily 7) If you find an error on WEBLOGIC, whether you can trace the same from REVELEUS logs ? 8) How do you identify the root cause for core dump and how do you debug, what are the commands 9) PL/SQL & SQL related questions 10) UNIX Commands 11) Clustering concepts in WEBLOGIC 12) 

Purpose: To host Multiple RPD's & Multiple Presentation Services in a Single OBIEE & Weblogic Installation Following steps can be executed even on OBIEE 11.1.1.6.0 Step 1: Trigger rcu.bat and create required schemas, trigger RCU from the following location D:\obiee116\V29675-01\rcuHome\BIN Provide these schema names while executing Step 3 Step 2:  All the OBIEE servers should be up and running Step 3:  Trigger config.bat from the path below D:\obiee116\Oracle_BI1\bin\config.bat Post configuration you can see these new folders in your OBIEE installed folders Please feel free to post your comments on queries related to Multiple RPD & Presentation service deployments