3.1.3.1 Generating Change Logs with T2T

The change log captures data which is added, deleted, or modified in the FSDM table. Data is initially moved from the staging table to the FSDM table through T2T. Once this is done, any modifications made such as adding new data, changing the data, or deleting the existing data are recorded in the change log table.

For example:

• Records are moved from the staging area into the FSDM table through T2T on day 1.
• A row is deleted from the FSDM table.
• Records are moved from the staging area into the FSDM table through T2T on day 2.
• A row is inserted into the FSDM table.

Both the deleted and added rows are displayed in the change log table.

This example mentions two scenarios for displaying data in the change log table: a deleted value and an inserted value. A third scenario is if a value is changed in the column of a table. In this case, the old and new values are both captured in the change log.

To generate the change log, you must provide CHGLOG_CAPTURE as the DT name in the Rule Name field and the name of the table that you want captured in the change log in the Parameter List field as mentioned in Adding Tasks to a Batch. Additionally, to delete a table, the DT name must be TRUNC_FSDM_TBL.