Change sequence in message

[gseckin]

We use qlik and in message qlik generates Change Sequence field, and we use oracle as source. Is this changesequence field coming from database or qlik generates this? 

[john_wang]

Hello @gseckin ,

Change Sequence number is a monotonically increasing value which generated by Qlik Replicate.

Hope this helps.

John.

[gseckin]

Thanks, does it use SCN from oracle database? What is the logic behind creating change sequence? 

[john_wang]

Hello @gseckin ,

Honestly, I’m not completely sure. While the SCN and the TIMESTAMP can be converted between each other, they are more closely related to the commit time of the transaction that contains the change record. You can find more detailed information [here].

Regards,

John.