if we increase the number of dimensions will the rows in
fact table increase or decrease??
- 3 Answers
- 8106 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / asha
Number of rows wouldn't increase. Number of cloumns will
increase in fact table as we will have to store the keys of
those dimensions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
What is a view as it relates to system modeling?
What is a general purpose scheduling tool?
How to generate the cubes in framework manager?
Explain can report net connect multiple datasource at a time in report creation time?
How can we run the graph?
What is the difference between data warehouse and operational systems?
What is a ETL/ How does Oracle support the ETL process?
What are session timeout and application timeout? Where we have to do this process?
What is the metadata extension?
How can you communicate with web server (apache or iis) from coldfusion?
Teradata 
