How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Answer / madhu
Dimension tables contain descriptions that data analysts use as they query the database.
|Is This Answer Correct ?||1 Yes||0 No|
How do you work in a multi user environment? What are the steps?
What are the things you can do in the BMM layer?
How do you define the relationship between facts and dimensions in BMM layer?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
Can you migrate the presentation layer to a different server.
What is connection pool and how many connection pools did you have in your last project?
What is level based metrics?
Define repository in terms of OBIEE?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
What is object level security?