if we increase the number of dimensions will the rows in
fact table increase or decrease??

Answers were Sorted based on User's Feedback



if we increase the number of dimensions will the rows in fact table increase or decrease??..

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

if we increase the number of dimensions will the rows in fact table increase or decrease??..

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

if we increase the number of dimensions will the rows in fact table increase or decrease??..

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

Post New Answer

More Data Warehouse General Interview Questions

What is dimensional modelling?

0 Answers  


explain about balanced dimension,

0 Answers  


what are the types of dimension tables

19 Answers   Infotech,


What is the difference between a W/H and an OLTP application?

5 Answers  


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

0 Answers  






4.Explain Snowflkeschema ?

6 Answers   EDS, HCL, IBM, iFlex, TCS,


What is the definition of cube in datawarehousing?

0 Answers  


What are the difference between snow flake and star schema?

0 Answers  


What is loop in data warehousing?

0 Answers  


what type of raid setup would you put your tx logs?

0 Answers  


What are the differences between star and snowflake schema?

0 Answers  


What is a linked cube?

0 Answers  


Categories