3.1.3.1.1 <Enter Concept Title Here>
(Required) <Enter a short description here.>
The following table describes the functions of the different components in the change log:
Table 3-1
| Component | Description |
|---|---|
| Wrapper | The Wrapper contains logic that is required to record all changes (inserted, updated, and deleted data) in the log table. |
| Metadata table | The metadata table contains the metadata to support the wrapper. |
| FSDM table | The table in which the data is added, deleted, or modified. |
| AAI | AAI creates the DT which helps to execute the wrapper and run the T2T. |
| Change log table | The change log table captures the change log data after the wrapper is executed. |
For the Metadata table component, the following values are available as metadata and can be captured in the change log:
Table 3-2 T2T Change Log Metadata Table Component Values
| Value | Description |
|---|---|
| Table Name | This value is the name of the FSDM table in which a change has been made. |
| Table’s Column Name | This value is the name of the FSDM column in the table in which a change has been made. |
| User Defined Primary Key | This value is the primary key of the column in which a change has been made. |
| Source Table Name | This value is the name of the source table in which a change has been made. |
| Source Table’s Column name | This value is the name of the column in the source table in which a change has been made. |
| Table Enable Flag | This value must be changed to N if you do not want to capture the changes made in a table in the change log. The default value is Y. |
| Table’s Column Enable Flag | This value must be changed to N if you do not want to capture the changes made in the column of a table in the change log. The default value is Y. |
| Customer Notification Suppress Flag | This value indicates whether the customer is notified of the change through email or not. |
| Additional Columns | This value is used to mention any additional columns of the table whose changes must be captured in the change log. |
For the Change log table component, the following values are available:
Table 3-3 T2T Change Log Table Component Values
| Value | Description |
|---|---|
| Table Name | This value is the name of the FSDM table in which a change has been made. |
| Column Name | This value is the name of the FSDM column in the table in which a change has been made. |
| Source File Name | This value is the name of the source extract file from which the field with the changed value was loaded. |
| Source Field Name | This value is the name of the field with the changed value in the source extract file where the value is changed. |
| Format | This value is a textual representation of the colum or field format or data type. |
| Change Entry User Identifier | This value is the identifier of the person who entered the change. This is a unique identifier for the user who makes the change. |
| Change Entry User System Logon Identifier | This value is the user name of the user who makes the change. |
| Change Date | This value is the date on which the change was made. |
| Change Time | This value is the time at which the change was made. |
| Old Value | This value is the old value which was assigned to the specified table column. |
| New Value | This value is the new value which is assigned to the specified table column. |
| Key1 | This value is the textual representation of the value associated with the first column in the Primary Key or the user-defined primary key of the table containing the changed record. |
| Key2 | This value is the textual representation of the value associated with the second column in the Primary Key or the user-defined primary key of the table containing the changed record. |
| Key3 | This value is the textual representation of the value associated with the third column in the Primary Key or the user-defined primary key of the table containing the changed record. |
| Key4 | This value is the textual representation of the value associated with the fourth column in the Primary Key or the user-defined primary key of the table containing the changed record. |
| Change Type | This value is the code that indicates whether the change is an insert (add), a delete (removal), or an update. |
| Customer Notification Suppression Indicator | This value indicates whether the customer is notified of the change through email or not. |
| Source System | This value is the source system from which this data content is extracted. |