Unique run identifier

When using Business Intelligence Exchange (BIX), you can provide a unique run identifier for each BIX extraction process to mark additions to both parent and child tables in the database, and parent and child CSV files. This enables you to accomplish the following actions after BIX extraction process:

• Easily identify all inserted records for a particular BIX extract run, both in the main table for a class and in subsidiary tables created for page lists, page groups, and value lists in the class.
• Delete records from a failed BIX run so that an extract can be re-run without producing incorrect or redundant data.

Two fields have been added to the main table for each extracted class in the database, pxExtractDateTime.TIMESTAMP and pxRunIdentifier VARCHAR(255).

The pxExtractDateTime field has also been added to all subsidiary tables for the class in the database.

The value of the pxExtractDateTime field matches the value of pyLastUpdateTime in the table pr_extract_time for the run. This allows you to perform a join action and obtain all of the records inserted for a BIX run.

You can also include a run identifier through the –k parameter option. For details, see BIX parameters and command-line arguments.

BIX can still run in backward compatibility mode for tables without new fields. If the new fields exist in the database, they are filled in by BIX; otherwise, BIX runs in backward compatibility mode.