by Ludek Bob Jankovsky, 10-Sep-2008 (ETL PATTERNS)
It could be named "Dream about metadata driven ETL". The schema depicted all elements what should participate in the ETL generating process separately to keep the system high manageable.
Following sources should be considered for ETL generating:
Repository
Data model, Data dictionary (metadata – static part)
ETL mappings (metadata – dynamic part)
ETL Approach
Design stereotypes
Functional patterns
Environment
Platform specific templates
Metadata layer and Generator interfaces
There are following success factors of metadata system:
Layered understanding – Business meaning of ETL mapping metadata has to be strict separated from technical implementation of mapping.
Reduce redundancy – such part of mapping coming from data model, design standards and ETL stereotypes (audit columns, surrogate keys... ) should not be explicitly defined in logical metadata.
Consistency – Consistency between metadata on various layers and physical implementation has to be assured (on both process and technical level)
