if we increase the number of dimensions will the rows in
fact table increase or decrease??
Answer Posted / pratap gangula
The number of rows in a fact table depends upon the grain of the fact. Dimensions can only describe the data in the fact table. Adding more dimensions will not increase the number of rows unless it impacts the grain of the fact. e.g You have fact at the granularity of day and u want to now add time intervals dimension.... this will increase the number of rows in fact.
Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
What is data validation strategies for data mart v?
What is Active Datawarehousing?
What are the steps involved in designing a fact table?
what are the other factors of the database on which the loading performance depend?
What are steps we have to follow in designing the userfriendly universe?
How do we design a universe?
Why should you put your data warehouse on a different system than your oltp system?
What is a relationship?
Is union transormation is active transformation?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the methodologies of data warehousing?
Explain how to export mappings to the production environment?
What is the very basic difference between data warehouse and operational databases?
What is conformed fact?
What is the difference between filter and lookup transformation?