Friday, 1 May 2015

Apps Associates Interview Questions

1) How Aliasing helps in Data modelling?
2) What is a role playing dimension and non confirmed dimension?
3) What are pre-requisites for joining a physical table  directly with Logical Table?
4) How to use a variable in where clause in BMM Layer?
5) What are the pre-requisites for setting the content level in fact table?
6) What is a level based measure?
7) What is a parent child hierarchy and tell the example?
8) What is Master Detail Linking?
9) What is a Factless fact table?
10) Difference between Group by and Partition by?
11) What is ETL and ELT?
12) Architecture of OBIEE 11g?

No comments:

Post a Comment