Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1722 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 is Discrete and Continuous data in Data mining world?
Explain what are the various transformation available?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is Grain & Granularity in Data Warehouse.
What is Snow Flake Schema design in database?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What are the different types of data warehouses?
Tell me one example for junk dimension?
How do you setup Lo-cockpit?
What is operational data store (ods)?
How can we do data cleaning?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Teradata 
