Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Preserve record order on Write

Preserve record order on Write

You can retain the order number of the changed record when you capture the changed record from a CDC source to a target table. This property enables you to avoid inconsistencies between the CDC source and target. You cannot use the preserve record order on write property when you run an elastic mapping.
When you modify a single record in a row several times in a CDC source, enable the
Preserve record order on write
option in the advanced target property to retain the order number of the changed record when you write the changed record to the target table.
For example, you have a record in the following CDC source table in which you have performed multiple of operations:
Emp ID
Emp Name
Emp Description
RowType
RowID
1
John
L1
Insert
1
1
John
L2
Update
2
1
John
L3
Update
3
Here, assume that the
RowID
shows the order of the changed record in the CDC source table.
The Secure Agent writes the following changed record along with the order number in the target table:
Emp ID
Emp Name
Emp Description
RowType
RowID
1
John
L3
Update
3