What is a Fact table?
Submitted by: AdministratorFact Table contains the measurements or metrics or facts of business process. If your business process is "Sales" , then a measurement of this business process such as "monthly sales number" is captured in the Fact table. Fact table also contains the foriegn keys for the dimension tables.
Facts are organized in a table is called Fact table.
A Fact is a numeric values or a Business measure.
Every numeric is not a fact. a numeric which occupied a key performance indicator is called Facts
A Fact table contains a Facts at lower granularity level
Submitted by: Administrator
Facts are organized in a table is called Fact table.
A Fact is a numeric values or a Business measure.
Every numeric is not a fact. a numeric which occupied a key performance indicator is called Facts
A Fact table contains a Facts at lower granularity level
Submitted by: Administrator
Read Online General Datawarehousing Job Interview Questions And Answers
Top General Datawarehousing Questions
☺ | What is SCD1 , SCD2 , SCD3? |
☺ | What is ODS? |
☺ | Explain piconet? |
☺ | Explain the Difference between OLTP and OLAP? |
☺ | Explain What are the Different methods of loading Dimension tables? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |