3.1.4 Phase IV: This is the modelling phase where
the schema of the target DW is modelled. This is
where MDM comes into play. However, Kimball’s
MDM guidelines will be applied on the IHL’s data
inconsideration of MDEC jobs to drive the schema
of the DW model. Like every other DW that
conforms to Kimball’s approach, it consists of four
basic steps.
3.1.5 Phase IV: This phase is where the vital
extraction transformation and loading process is
built and executed an. DW obtains its data from
various and often heterogeneous data sources. For
these reason, the data need to be transformed into a
consistent format needed to be stored in the DW.
Thus the ETL becomes imperative. This phase
begins with the extraction of data from the various
identified data sources. The data extracted will be
converted and stored in a single database.