Online analytical processing (OLAP) Question:

What are Fact Tables?

OLAP Interview Question
OLAP Interview Question

Answer:

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. 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.


Previous QuestionNext Question
What are Database roles in OLAP?Where is Data Sources in OLAP?