What Are Title 10 Decision Points Of Data Warehousing?

1.	What Are Title 10 Decision Points Of Data Warehousing?
Answer» Identify a fact table. Identify the dimension TABLES. Define the attributes of the entities. Define the granularity of the fact table (how detailed do you want the DATA to be). Define pre-calculated key figures. Identify SLOWLY changing dimensions. Identify AGGREGATES. How long will the data be kept. How often is the data EXTRACTED. From which system is the data to be extracted.

Answer»

Identify a fact table.
Identify the dimension TABLES.
Define the attributes of the entities.
Define the granularity of the fact table (how detailed do you want the DATA to be).
Define pre-calculated key figures.
Identify SLOWLY changing dimensions.
Identify AGGREGATES.
How long will the data be kept.
How often is the data EXTRACTED.
From which system is the data to be extracted.

Discussion