What is a fact table?
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 many-to-many dimensional model in datawarehousing ?
Why null values are mapped as 0 in fact tables?
Which kind of index is preferred in DWH?
Explain what is difference between query studio and report studio?
Explain Association algorithm in Data mining?
What is MODEL is Data mining world?
What is loop in data warehousing?
What are the different types of fact tables used in data warehousing?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
Which are the olap tools available that are supported by oracle?
What is the differences between star and snowflake schemas?
Explain in detail abt measure objects? And what is the use of it? How to create it?