These steps are part of the larger task of Defining a staging table replication step. When you complete the steps for Specifying processing options for a staging table replication step, return to Defining a staging table replication step.
To specify staging table options:
In the Condensed group box, select Yes if you want the staging table to contain only the most current value for a row, or select No if you want the staging table to contain a history of changes to a row.
In the Complete group box, select Yes if you want the staging table to contain all the rows that you want to replicate from the source table, or select No if you want the staging table to be empty when it is created and to have rows appended as changes are made to the source table.
Select Register as external replication source to give the staging table its own row in the register table, where it is referenced as SOURCE_OWNER and SOURCE_TABLE.
Select Register as internal staging table if you do not want the staging table to have its own row in the register table. The staging table will be referenced at CCD_OWNER and CCD_TABLE in the row for the associated replication source.
Select Unit of work (UOW) columns if you want a noncomplete, condensed staging table that includes extra columns from the UOW table.
Click OK to save your changes and close the window.
Return to Defining a staging table replication step.