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
- 9585 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 |
Is union transormation is active transformation?
What is cubes?
Explain degenerate dimension table?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain piconet?
What is Cognos script editor?
What is surrogate key? Explain with examples.
Explain the data type of the surrogate key?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is the use of incremental aggregation? Explain me in brief with an example?
What is a Data Warehouse?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Teradata 
