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
- 9601 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is perform recovery?
What are non-additive facts in detail?
Explain what is the metadata extension?
Which columns go to the fact table and which columns go the dimension table?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is cubes?
What is cost benefit analysis (cba)?
Where the cache files stored?
How many types of facts and what are they?
Explain what is the data type of the surrogate key?
How can we schedule the graph in unix?
Who needs data warehousing?
Explain where do we use semi and non additive facts?
what is an use case?
What are the differences between star and snowflake schema?
