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
Explain where do we use semi and non additive facts?
What are the different methods of loading dimension tables?
what are the other factors of the database on which the loading performance depend?
Explain what are the advantages of query studio compared to report studio?
What is the difference between filter and lookup transformation?
What a static and local variable?
Explain what are fact, dimension, and measure?
Explain what is real time data-warehousing?
What is data analysis? Where it will be used?
What are the key columns in Fact and dimension tables?
Explain what is the difference between datawarehouse and bi?
Why denormalization is promoted in universe designing?
Why facts table is useful in representing the data?
How can you clear the cache?
How to create different types of templates?