If I have table T1 and table T2
T1 has 250 cols and 10,000 rows
T2 has 2 billion rows and 10 cols
Which one would be Fact table and which one would be
Dimension table and why ?
Answer Posted / henry
Dimensions are wide - facts are deep.
T1 will be dimension table (example "customer" with all the
related attributes like address, tel etc)
T2 will be your fact table (example "orders") which uses
one column as surrogate key to link to T1 ("customers" in
this case)
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
what are the all possible features supported modify stage?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is execution plan?
how much memory space occupied real time project (roughly)?
How to limit the max no of rows retrieved in the report?
What is the 4 + 1 view model as it relates to system modeling?
Explain what are the tasks that loadmanger process will do?
what are different storage options supported by oracle ?
How can you implement many relations in star schema model?
What is the difference between filter and lookup transformation?
What are the differences between star and snowflake schema?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are the differences between datamart vs. Reporting cube?
Explain how to export mappings to the production environment?
What is the purpose of cluster analysis in data warehousing?