Timestamp-based downloads require a timestamp column for each synchronized table in the consolidated database to track when changes are made to rows.
The timestamp column records the last time synchronization changes were made in the consolidated database. This column resides on the consolidated database, and it should never be synchronized or changed by another process.
This page allows you to specify the name of the timestamp column, as well as whether the column should be added to synchronized tables or whether shadow tables should be created to hold the timestamp.
This page has the following components:
Timestamp column name Shows the name of the timestamp column.
Use timestamp column in synchronized tables Select this option to add timestamp columns to your synchronized tables on the consolidated database. Choose this option if you are willing to change the consolidated table definition. When you deploy the model, a timestamp column is added to each synchronized table in the consolidated database if it does not already exist.
If you try to redeploy this model to the consolidated database, you are prompted to update the consolidated schema in the model.
Use shadow tables to hold timestamp columns Select this option if you want to create a shadow table for each synchronized consolidated database table. Choose this option if you don't want to modify the schema of the synchronized consolidated database by adding timestamp columns. The shadow tables have two columns, one holding the primary key for the table, and the other holding the timestamp. Shadow tables are created with the same owner as the base table.