Data extraction audit

Data extraction auditing creates a correlation between each data extraction and the selection that was used in the data extraction.

The audit table is a data table that is created in the relational target database. When data extraction auditing is enabled, a fact table audit record is added to the audit table each time a data extraction is run.

The audit table has the same name as the fact table appended with the suffix _AUDIT. The audit table has a unique ID for each record. The ID value is also stored in the AUDITID field of each fact table record so that each data record in the fact table has a reference to the audit table record.

For example, to determine the age of fact table data records, a SQL query can be built linking the relationship between the fact table AUDITID and the ID field in the audit record.

For more information about the contents of the audit table, see Audit table.

Attention: Data extraction auditing can slow down a selection run. You can turn both auditing and selection state preservation on or off. For more information, see Setting Selection Manager options.