Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
PGN
Creator II
Creator II

Header Sequence Column Question

I received this from a user, anyone have any ideas?


A question on the Attunity header sequence column

We discussed latency if it occurs over the midnight hour if a transaction was delayed for 10 min, say for one specific member with a primary key, say on the member table and the primary key is 1234567 and I have additional members on that table as 1234568 and 1234569, is it possible that Attunity would send the two records with a higher header sequence number before a record from the same table with a lower header sequence number into the CDC tables?

 

 

Labels (1)
1 Solution

Accepted Solutions
SwathiPulagam
Support
Support

Hi,

No, In ideal condition (Assume there are no task errors and the target is not a messaging system like Kafka)Replicate will send the records based on commit timestamp in incremental order. The time part in the header__change_seq column refers to the commit time of the transaction that includes the change record. If the transaction has members 1234568 and 1234569 committed before 1234567 then you will see a lower header sequence number for pk 1234568,1234569 and pk 1234567 will be inserted later in __ct table with a higher header sequence number.

 

Thanks,

Swathi

View solution in original post

2 Replies
SwathiPulagam
Support
Support

Hi,

No, In ideal condition (Assume there are no task errors and the target is not a messaging system like Kafka)Replicate will send the records based on commit timestamp in incremental order. The time part in the header__change_seq column refers to the commit time of the transaction that includes the change record. If the transaction has members 1234568 and 1234569 committed before 1234567 then you will see a lower header sequence number for pk 1234568,1234569 and pk 1234567 will be inserted later in __ct table with a higher header sequence number.

 

Thanks,

Swathi

PGN
Creator II
Creator II
Author

Great! Thanks for getting back to me so quickly.