Online analytical processing (OLAP) Question:

Download Job Interview Questions and Answers PDF

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.

Download OLAP Interview Questions And Answers PDF

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