|
When is ETL Source to Target Table used?
This is the complete end to end
source-to-target schema, which should be coming out of the Data Warehouse Design & Architecture
. This
templates starts getting populated from the beginning of the design
phase and gets finalized with the end of design phase.
Why is it used?
One needs to tie-up the Extraction
and Transformation
process into a single document to provide and end-to end picture.
This also helps in establishing Data Quality assurance routines.
What it contains?
It contains one record each for
each moment of data as it moves from the source system to destination
system. |
