"A dimension table is wide but the fact table is deep," explain the statement in your own words.
806What is junk dimension? What is the difference between junk dimension and degenerated dimension?
584What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
556Post New Data Warehouse General Questions
What is incremintal loading?
What are the differences between star and snowflake schema?
What are aggregate transformation?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is the use of dimensional modeling in data warehousing?
Explain how to get the first 100 rows from the flat file into the target?
What are algorithms provided by Microsoft in SQL Server?
How to create prompts in report net?
Explain what are the methodologies of data warehousing?
What is cubes?
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?
What are universe requirements?
Explain piconet?
Explain what is the difference between datawarehouse and bi?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.