Number of rows wouldn't increase. Number of cloumns will increase in

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

Question Posted / asha

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain what are data marts?

1127

How can you clear the cache?

1015

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1040

What is Operational Data Store?

1079

Explain what is the difference between powerplay transformer and power play reports?

1159

What are steps we have to follow in designing the userfriendly universe?

978

Explain degenerate dimension table?

1051

How to pivot row data using informatica?

965

Explain bus schema?

979

Explain what are the various reporting tools in the market?

983

What is the difference between power center & power mart?

985

What is aggregate fact table?

994

Explain vldb?

1038

Describe a data warehouse.

989

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1057