What are fact tables and dimension tables?
Answer
As mentioned, data in a warehouse comes from the transactions. Fact
table in a data warehouse consists of facts and/or measures. The nature of data
in a fact table is usually numerical.
On the other hand, dimension table in a data warehouse contains fields used to
describe the data in fact tables. A dimension table can provide additional and
descriptive information (dimension) of the field of a fact table.
e.g. If I want to know the number of resources used for a task, my fact table
will store the actual measure (of resources) while my Dimension table will
store the task and resource details.
Hence, the relation between a fact and dimension table is one to many.
More Related Links
Answer - OLTP: Online Transaction and Processing helps and
manages applications based........
Answer - A data cube stores data in a summarized version which
helps in a faster analysis of data..........
Answer - A snowflake Schema in its simplest form is an
arrangement of fact tables.........
Answer - Data Warehousing helps you store the data while
business intelligence.....
Answer - Dimensional modeling is often used in Data
warehousing.......
|