Detailed Design (user interface, data model, ETL)
¡Identifying the key business processes and dimensionality and mapping these over time to be sure there are no
gaps. This is used to identify the fact table grain, associated
dimensions, attributes and
hierarchical drill paths and facts.
Source-to-Target (or
Target-to-Source) Maps are generated.
§the
logical data model is defined with relationships between the entities and from that the physical data model is designed giving
the tables with their
primary keys and subsequent indexes.
§Extract – Transform – Load – involves two efforts: initial population (snapshot) and the refresh (keeping the data warehouse
current based upon a
pre-determined frequency.
The Data Warehouse Lifecycle Toolkit Ralph Kimball
