What are Fact Tables?
Submitted by: AdministratorData 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.
Submitted by:
Submitted by:
Read Online OLAP Job Interview Questions And Answers
Top OLAP Questions
☺ | Explain about OLAP? |
☺ | What is ROLAP? |
☺ | Explain about the database marketing application of OLAP? |
☺ | Explain about aggregations? |
☺ | Explain about MOLAP? |
Top Application Program Categories
☺ | AutoCAD Interview Questions. |
☺ | Microsoft Office Interview Questions. |
☺ | Microsoft Outlook Interview Questions. |
☺ | Microsoft Excel Interview Questions. |
☺ | MATLAB Interview Questions. |