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
- 9233 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
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain why dimenstion tables are denormalized in nature?
What are the different types of data warehousing?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How can we run the graph? How can we schedule the graph in unix?
Store (and count) non-fact records?
What are the stages that are required in data warehousing?
Explain what is the advantages data mining over traditional approaches?
Explain why denormalization is promoted in universe designing?
How do you define data block size?
After the complete generation of a report who will test the report and who will analyze it?
How can you implement many relations in star schema model?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is data mart in data warehouse?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
