Explain what is the difference between power center & power mart?
No Answer is Posted For this Question
Be the First to Post Answer
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is a core dimension?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is a Data Cube?
How many types of facts and what are they?
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 difference between snow flake and star schema.
What is the metadata extension?
How do we design a universe?
What are templates in which way it is help full?
Explain what is fact less fact table? Where you have used it in your project?
what is table partitioning? How it is useful to warehouse database?