|
When is Source system mapping matrix used
This template is created prior to
the extraction design. This template is among the first one to be
used in the Data Warehouse design phase.
When is it used?
Please refer to Source Systems Mapping
in Data Warehouse Design & Architecture
phase for the context of the template.
This template is created prior to
the Extraction design. This template is among the first one to be
used in the Data Warehouse design phase.
Why is it used?
Before one gets onto making Extraction
routines, its important to finalize on which data element will come
form which source and why.
What it contains?
It contains the field by field mapping
across the data elements needed to populate the Dimensional
Model and the fields in the Source Systems
.
Why is it used
Before one gets onto making extraction
routines, its important to finalize on which data element will come
form which source and why.
What it contains
Is contains the field by field mapping
across the data elements needed to populate the dimension model
and the fields in the source systems. |