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

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

Question Posted / abhishek

3 Answers
9710 Views
IBM, I also Faced
E-Mail Answers

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

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

0 Answers IBM,

Explain what is partitioning? What are the types of partitioning?

0 Answers

What are the various tools? Explain name a few?

0 Answers

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

0 Answers

Can we have more than one time dimensions in a Schema(Star or Snowflake)

1 Answers ASD Lab, IBM,

What are various warehousing tools?

0 Answers

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

0 Answers L&T,

In a star schema, are foreign key constraints between facts and dimensions neccessary?

0 Answers

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

0 Answers

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?

0 Answers

Best institute for MS BI training in Hyderabad, India?

4 Answers

What are universe requirements?

0 Answers

For more Data Warehouse General Interview Questions Click Here