Explain clustering algorithm?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain what are the basic needs to join two sources in a source qualifier?
How to know the time taken for particular report execution?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
How many ways we test the universe & Report?
When should one use an MD-database (multi-dimensional database) and not a relational one?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain conformed fact?
What are aggregate fact tables ? why they are needed? give an example
What are components of report studio?
What are session timeout and application timeout? Where we have to do this process?
What is multi-dimensional analysis?