Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9313 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
Define Data Warehousing?
Explain a mapping, session, worklet, workflow, mapplet?
What is the difference between filter and lookup transformation?
Database in use is oracle?
I need a good brd and uc template?
How to handle multi value dimensions?
What is a data profile?
Can we start and stop single session in concurent bstch?
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain me what is vldb?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain what is metadata reporter?
Explain the structure of cold fusion?
Explain difference between e-r modeling and dimentional modeling?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
