Data Warehouse Manager Interview Question:

Tell me what are the steps involved in designing a fact table?

Submitted by: Administrator

The fact table allows the data to be represented in the detailed manner. It has an association with the dimensional table.

The steps that are required to design the fact table includes:
Identify the business process for analysis so that all the process can be defined and used with the complete details provided by the business process.

Identify the measures, constraints, facts and keys before designing the fact table. The questions have to be asked during the business process regarding the table that has to be created and the purpose of it.

Identify the dimensions for facts like product dimensions, location, time, etc. This phase also include the analysis of the components that are required to be involved.

List of the columns takes place that describe the dimension and the lowest level of detail is to be found out to be used in the fact table.
Submitted by: