Change Data Capture Pipeline
For implementing a CDC Data Pipeline within the data warehouse the ExMeX Framework Core introduced with release 2.9.0 new table and column stereotypes for data modeling.
To use this function within PowerDesigner at least version 2.0.0 of the plugin PowerDesigner Extension - TEDAMOH ExMeX Data Vault is required!
To populate full and partially CDC tables the ExMeX Framework Core introduced two new Load Process Step (LPS) pattern (LoadPatternId with ODLB = 16 and LoadPatternId with HiZ = 17).
- After data modelling in PowerDesigner, regenerate the metadata.
- After generating the metadata and adapting the scripts, install the metadata.
Reference Data Stage Pipeline
For implementing a Reference Data Stage Pipeline within the data warehouse the ExMeX Framework Core introduced with release 2.11.0 a new table stereotype for data modeling.
To use this function within PowerDesigner at least version 2.0.0 of the plugin PowerDesigner Extension - TEDAMOH ExMeX Data Vault is required!
To populate non-historized Reference Data Stage tables the ExMeX Framework Core introduced a new Load Process Step (LPS) pattern (LoadPatternId = 18).
- After data modelling in PowerDesigner, regenerate the metadata.
- After generating the metadata and adapting the scripts, install the metadata.
One To One Data Copy Pipeline
For implementing a One To One Data Copy Pipeline within the data warehouse the ExMeX Framework Core introduced with release 2.12.0 new table stereotypes for data modeling.
To use this function within PowerDesigner at least version 2.2.0 of the plugin PowerDesigner Extension - TEDAMOH ExMeX Data Vault is required!
To populate One To One Data Copy tables the ExMeX Framework Core introduced a new Load Process Step (LPS) pattern (LoadPatternId = 19).
- After data modelling in PowerDesigner, regenerate the metadata.
- After generating the metadata and adapting the scripts, install the metadata.