Appendix C: Tracking Changes in Data

The optional 'annotations' feature allows you to store additional data about how each object, attribute or association have been changed due to processing of data under Extract, Transform, and Load components.

These tracking attributes store data about creation, modification and deletion operations and can be inspected via CSV reporting. Collect this information for the CSV report by setting XML <annotations> node to the respective module configuration in the Extract or Load settings or to extension configuration for the Transformer. The available annotations level values are 'None' and 'Basic' and 'ObjectIDTracking'.

• When the annotations level is set to None, no tracking information is collected.

• When the annotations level is set to Basic, then all tracking information connected with creating, updating and deleting performed on objects, attributes and associations are recorded.

• When the annotations level is set to ObjectIdTracking, then the patterns that were used in ObjectID conditions and definitions are recorded.

Example for Extractor and Loaders:

<configuration ...>

...

<annotations level = "None" />

</configuration>

Example for Transformer’s Extensions:

<extension ...>

...

<annotations level = "Basic" />

</extension>

Example of using ObjectIdTracking level in BaseMapping Extension Node:

<extension name="BaseMapping">

   <mapping locator="..\Mappings\DefaultBaseMapping.xml" />

   <annotations level="ObjectIdTracking" />

</extension>

For more information about passing report of tracking data to CSV, see Appendix B: CSV Reporting.