Tracking column and Document ID should be same?


#1

There is inserted_time column and username column in a mysql table. I have to pick the new records daily from mysql.
I want to use inserted_time as a tracking column and use sql_last_value.
but inserted_time is not unique . fields username+inserted_time is unique.

Now is it possible to have tracking_column=> inserted_time and document_id=> username+inserted_time. Will there be any data loss or data duplicates ?

Do we have to keep both tracking_column and document_id as same?


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.