Online analytical processing (OLAP) Question:
Download Job Interview Questions and Answers PDF
What are Fact Tables?
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 Question | Next Question |
What are Database roles in OLAP? | Where is Data Sources in OLAP? |