if we increase the number of dimensions will the rows in
fact table increase or decrease??
Answer Posted / 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 View All Answers
What are the different types of fact tables used in data warehousing?
What is the difference between aggregate table and materialized view?
What are target types on the server?
What should I have in mind when building olap solution from scratch?
How many types of facts and what are they?
Explain what are the methodologies of data warehousing?
What is Active Datawarehousing?
What is critical column?
Explain why fact table is in normal form?
What is metadata in context of a datawarehouse?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is Operational Data Store?
Explain the difference between dw and bi?
What is the difference between er modeling and dimensional modeling?
Explain what is the advantages data mining over traditional approaches?