if we increase the number of dimensions will the rows in
fact table increase or decrease??
- 3 Answers
- 8389 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain what is metadata reporter?
Explain dimensional modelling?
Explain what does level of granularity of a fact table signify?
What is a relationship?
Explain how to get the first 100 rows from the flat file into the target?
Explain the difference between keylokup and joiner?
What is the main difference between star and snowflake star schema? Which one is better and why?
Define data warehouse?
what are the major three types of modeling used?
Can you state some of the innovations throughout history?
Explain what is the extension of file to save template?
How to create prompts in report net?
What is the main difference between inmon and kimball philosophies of data warehousing?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is scd1 , scd2 , scd3?
