Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1645 Views
- I also Faced
- E-Mail Answers
Answer / dipti a
Fact Table is the central table which has factual information. It contains numeric information and measures.
Lets say if you need to capture sales data then centrally we can have sales table(fact table) which contains numeric information and surrounding to it, we can have dimensions table like product dimensions, date dimensions, store dimensions.
So this central fact table will contacts numeric information like Prize_of_product, Qualntity and along with same we can have dimension foreign keys like product_id, store_id, date_id and so on.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain some of modeling tools available in the market?
Explain what are the tasks that loadmanger process will do?
What are the differences between datamart vs. Reporting cube?
Explain what are slowly changing dimensions?
Which are the olap tools available that are supported by oracle?
What is the difference between narmal load and bulk load?
Why is business intelligence (bi) important in data warehousing?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is data cleaning? How can we do that?
Tell me one example for junk dimension?
Explain what is the difference between stop and abort?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Teradata 
