Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1727 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 |
What needs to be done while starting the database?
What is Discover and Execute in XMLA?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
What is surrogate key? Explain with examples.
Explain the hierarchies level data warehousing.
what is difference between scd2 and scd3
Explain what is a view as it relates to system modeling?
What are the differences between star and snowflake schema?
What is the difference between datawarehouse and bi?
what is an use case?
0 Answers InfoAxon Technologies,
What are templates in which way it is help full?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Teradata 
