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
- 9437 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 allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain multivalued dependency?
what are the all possible features supported modify stage?
What is operational data store (ods)?
How to create different types of templates?
Difference between ODS and Staging
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
5.Explain ODS ?
What is META DATA information in Data warehousing projects?
Explain how to generate iqd file from framework manager?
Teradata 
