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
- 9453 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
List down some of the real time data-warehousing tools?
Explain what is ods (operation data source)?
What is a cube in data warehousing concept?
What is execution plan?
What is surrogate key? Where we use it explain with example?
Explain grouped cross tab?
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain is olap databases are called decision support system true/false?
What is cost benefit analysis (cba)?
What are the data types present in bo? What happens if we implement view in the designer n report?
Where the cache files stored?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
How can we do data cleaning?
How can we schedule the graph in unix?
Explain what are necessary tasks to install reportnet software?
