if we increase the number of dimensions will the rows in
fact table increase or decrease??
- 3 Answers
- 8390 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / itesh
Yes, if we increase the dimension obviously that key need
to added in the fact ,
Ex
1 fact joined 1 dim of 4 key,
I have added 1 dim with 2 keys
Now my fact will be 8 keys.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Explain what is the extension of file to save template?
Where the data cube technology is used?
What are aggregate tables and aggregate fact tables?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain differences between star and snowflake schemas?
The same tier?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
How can you implement many relations in star schema model?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are the different types of datawarehosuing?
Is there any rownum object from which we can do this?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the difference between agglomerative and divisive hierarchical clustering?
What is the purpose of cluster analysis in data warehousing?
Explain what are the mapping paramaters and maping variables?
