Control tables
Control tables store metadata and configuration information that can be used for auditing purposes, or leveraged for downstream processing. For example, the attrep_cdc_partitions control table contains records of partitions created on the target platform. These records can be used to identify partitioned data that requires further processing.
Control tables are supported in both Data pipeline and Replication use cases. This topic describes the control tables that are created on the target platform when the corresponding table is selected in the task settings.
-
All control table timestamps are in UTC format.
-
Control tables are not created in Full Load only replication tasks.
-
Setting the replication task to DROP and CREATE the table if the target table already exists will not affect control tables.
-
The data task automatically creates the control tables on the target during runtime. If you prefer to manually create the tables, make sure that all column names and table names are lower case, apart from the Apply Exceptions table (
attrep_apply_exceptions), which should be upper case.
The control tables described in this section are as follows: