Interested to Buy Any Domain ? << Click Here >> for more details...
if we increase the number of dimensions will the rows in
fact table increase or decrease??
- 3 Answers
- 9616 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
What is the differences between star and snowflake schemas?
What are the different types of segments?
Explain the differences between normalizer and normalizer transformation?
What is the purpose of Dataware Control?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What are the various methods of getting incremental records or delta records from the source systems?
Suggest a good author for hyperion in data warehousing?
What is factless fact tables?
Explain why dimenstion tables are denormalized in nature?
What are the different methods of loading dimension tables?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What are the data types present in bo?
What should I have in mind when building olap solution from scratch?
What is a cube in data warehousing concept?
What are the various tools? Explain name a few?
