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

Replicate using oracle source found that some of the records are missed

need a quick help

Our CDC task got failed with redo log doesn't exist, once our DBA's are restored all redo logs and we have resumed with the timestamp, we have seen all the redo logs are processed successfully but after some time it got failed again with redo doesn't exist issue with another sequence number, we have followed the same process like restoring those redo logs and resuming the job with a timestamp.

After few days we have found that data missing in the target.

for suppose if we resume the task now by collecting the SCN number from the first failure, is it going to load the duplicates in target (or) it will load only the missing records (or) else do we have only one option FUll + CDC (or) else do we have any other option


Labels (1)
1 Solution

Accepted Solutions
lyka
Support
Support

Hello,

 

It will load duplicate however you can use the apply error handling and use MERGE and UPSERT

 

MERGE:

Duplicate key when applying an INSERT: > Update the existing target record:

 

UPSERT:

No record found for applying an UPDATE set to Insert the missing target record

 

Please note that when you use UPSERT, LOB support will be disabled

Hope this helps

 

Thanks

Lyka

View solution in original post

1 Reply
lyka
Support
Support

Hello,

 

It will load duplicate however you can use the apply error handling and use MERGE and UPSERT

 

MERGE:

Duplicate key when applying an INSERT: > Update the existing target record:

 

UPSERT:

No record found for applying an UPDATE set to Insert the missing target record

 

Please note that when you use UPSERT, LOB support will be disabled

Hope this helps

 

Thanks

Lyka