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 ?
- 3 Answers
- 8252 Views
- Extech, Principal Finance, I also Faced
- E-Mail Answers
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
Explain what are the mapping paramaters and maping variables?
What is difference between model & package?
List down some of the real time data-warehousing tools?
Explain the differences between normalizer and normalizer transformation?
Define Data Warehousing?
Explain what is power center repository?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the different types of fact tables used in data warehousing?
What is a general purpose scheduling tool?
What are various warehousing tools?
What needs to be done while starting the database?
What is the difference between view filter and report filter?
What is metadata in context of a datawarehouse?
What is mean by aggregate aware?
What is pre-emptive and non-pre-emptive?
