if we increase the number of dimensions will the rows in
fact table increase or decrease??
- 3 Answers
- 8388 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 |
How to define a cube??
What is MDX?
What is operational data store (ods)?
Explain what are data marts?
what are the other factors of the database on which the loading performance depend?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What are the different types of scd's used in data warehousing?
What is an er diagram?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is the difference between olap and datawarehosue?
Where the applications and where
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Teradata 
