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
How to drill through from a powerplay cube to reportnet?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is a data warehousing?
List any five applications of data warehouse.
What is vldb(very large databases)?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is a full backup?
What are the other names given to data warehousing?
What do you mean by static and local variable?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain what are data marts?
How do we design a universe?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is edw?
Explain difference between data ware house & data mart?