What is a fact table?
- 1 Answers
- 1050 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 about Control M JObs detaily?How to execute this.
2 Answers Scope International,
What are different deliverables according to phases?
How to use the tool Ontobulider
What is the use of dimensional modeling in data warehousing?
What are the key columns in Fact and dimension tables?
How does data mining and data warehousing work together?
Explain what are the different types of join operations?
how to find unique records in informatica level
What is the difference between snowflake and star schema?
What is difference between e-r modeling and dimensional modeling?
Explain is fact table?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Teradata 
