Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to insert change_sequence as number of transaction happened on source in target.

Gokul M SApr 17 2025

we capture all transaction happened on source in our target staging, we need a sequence value inserted in replication target to understand sequence of operations happened on the source record. this would be new column in target let us call "change_sequence" which is not present in source.

Ex: table a source
col1(bk) col2
1 32

table a target
col1(bk) col2 change_sequence change_action
1 1 1 I

1 2 2 U

1 32 3 U

Comments
Post Details
Added on Apr 17 2025
0 comments
75 views