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
- 9305 Views
- Extech, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / nithin
A table being set as a Fact or Dimension depends on the
kind of data it stores.Measures and keys are stored in
Facts and Dimension stores a primary key and other
information depending up on the dimension.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Can you brief about the Data warehouse project you worked on?
How can you set the client management?
what are different storage options supported by oracle ?
Explain which columns go to the fact table and which columns go the dimension table?
Explain what is the difference between power center & power mart?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is operational data store (ods)?
Explain hybrid slowly changing dimension?
Explain me what is vldb?
Explain what is the difference between powerplay transformer and power play reports?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What are the steps of implementing data warehousing?
Explain what is difference between query studio and report studio?
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?
What are aggregate transformation?
