WortmarkeTEDAMOH

Log in
updated 7:50 AM, Jun 26, 2020 Europe/Berlin
A+ A A-

General matters

Which Stereotypes for CDC are available?

For implementing a CDC Data Pipeline within the data warehouse the TEDAMOH ExMeX Framework introduced with release 2.9.0 new table…

For implementing a CDC Data Pipeline within the data warehouse the TEDAMOH ExMeX Framework introduced with release 2.9.0 new table and column stereotypes:

For the stage table (stereotype: Volatile Zone)

  • New column stereotype:

    CDC Compare Key (Mandatory)

    This stereotype identifies one or many columns which drives the compare to identify changes and capture them.

New table type: One Data Load Before (ODLB) - Contains the previous full load to which the current full load should be compared.

  • New table stereotype:

    SL - CDC One Data Load Before

    This table store all data which were available one data load before the current load. The ODLB table is used to execute the change data capture. Hint: Alternatively an existing history table can be used.

  • (New) Mandatory column:

    Hash-Diff CDC (Code: HashDiffCDC)

    This column stores a hash, generated with all non CDC Compare Key columns. It increases speed to identify changes.
    To ensure data quality it is recommended to use a domain for the Hash-Diff CDC column (see also the following topics).

New table type: Change Data Caputere (CDC) - Stores all detected changes

  • New table stereotype:

    SL - CDC Complete

    This table stores all data identified by the CDC Data Pipeline: I,U,D

    SL - CDC Partially

    This table stores exclusively deleted data identified by the CDC Data Pipeline: D

  • (New) Mandatory column:

    Status CDC (Code: StatusCDC)

    This column stores a flag, generated by CDC: I,U,D,X
    To ensure data quality it is recommended to use a domain for the Status CDC column (see also the following topics).
Posted 6 months ago

In which language will the seminars or trainings be held?

The seminars and trainings are usually held in English unless the description of the seminar or training explicitly states German…

The seminars and trainings are usually held in English unless the description of the seminar or training explicitly states German as the language of instruction.
If there are only German-speaking participants in the seminar or training in Germany, Austria or Switzerland, the language of instruction is German.

Posted 1 year ago