Explain What does level of Granularity of a fact table signify?
Submitted by: AdministratorGranularity
The first step in designing a fact table is to
determine the granularity of the fact table. By
granularity, we mean the lowest level of information
that will be stored in the fact table. This
constitutes two steps:
Determine which dimensions will be included.
Determine where along the hierarchy of each dimension
the information will be kept.
The determining factors usually goes back to the
requirements
Submitted by: Administrator
The first step in designing a fact table is to
determine the granularity of the fact table. By
granularity, we mean the lowest level of information
that will be stored in the fact table. This
constitutes two steps:
Determine which dimensions will be included.
Determine where along the hierarchy of each dimension
the information will be kept.
The determining factors usually goes back to the
requirements
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. |