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
- 9457 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 |
Explain what are the basic needs to join two sources in a source qualifier?
What is an OLAP (On-line Analytical processing) system?
How to generate iqd file from framework manager?
What is the differences between star and snowflake schemas?
How can we transform row to column?
How many repositories can we create in Informatica?
Explain what is a view as it relates to system modeling?
What is surrogate key? Where we use it explain with example?
What are various warehousing tools?
Explain is olap databases are called decision support system true/false?
Explain the importance of data warehouse?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Teradata 
