Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1561 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 |
Whether dimension table can have numeric value?
Difference between DSS & OLTP?
What is fact less fact table? Where you have used it in your project?
What is the function of etl when used in data warehousing?
What is a general purpose scheduling tool?
Explain what are the possible data marts in retail sales?
Which is the optimized method of extracting the data.
what are the other factors of the database on which the loading performance depend?
What is Drill by? drill through?
What is called data cleaning?
Compare ?Data mining? and ?Data Warehousing??
What is critical column?
Teradata 
