OBIEE 11g latest interview Questions

1. What are all the other objects you can use in physical layer other than tables?
ANS:FUNCTIONS,PROCEDURES,SELECT statement,Materialized views,OPAQUE

2. What is a materialized view?
ANS: Materialized view is a physical object and replica of the one or more master objects.It will refresh in an intervals.

3. Have you ever tried with de-normalized Database to build reports? If yes, How to handle?
ANS: Building reports on de-normalized data is not a best practice it leads to performance issues but we can build the reports. These are reports can’t be used for business analysis because the data will fluctuate non regular intervals.

4. Employee table, Department table

a) How to get the duplicate records from the employee table?
ANS: select * from employee group by EMPID having count(EMPID)>1;

b) How to establish a primary key, foreign key join between employee and department tables?
ANS:DEPARTMENT is the PRIMARY KEY AND EMPLOYEE is the FOREIGN KEY.

c) If I want to add another department to the each employee, what are all the ways to design the tables?
ANS:Create an another DEPARTMENT column to the EMPLOYEE TABLE.

5. Have to ever work with complex BMM layer? Not like star and snow flake schema? Generally what are all the objects it includes?
ANS:YES,It includes BRIDGE tables,LOOK-UP tables,HIERARCHIES,TIME SERIES functions,Complex calculations,SNOW FLAKE schema etc.