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).

Please always remember this:
  • 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).

Please always remember this:
  • 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).

Please always remember this:
  • After data modelling in PowerDesigner, regenerate the metadata.
  • After generating the metadata and adapting the scripts, install the metadata.