I am looking for some help regarding DIFF Snap.
Below is the scenario, I am working on:
I have two Source DBs - A & B. DIFF snap is being used to identify the eligible data for Insert, Update and Delete, and accordingly operations performed in Source B as Target DB.
Lets say 10 records are there in A
20 records are there in B
then DIFF will identify 10 records for deletion from B.
Now, the problem I am facing is,
if due to any data issue or connection failure, if no records are coming from Source A, then DIFF is identifying all records from B to flow in the deletion link, which eventually deleting all the data from B.
I dont want this to happen. I want my pipeline to stop/fail, if any such error happend in the source, so that target cannot be empty in any case.
I am using Error Pipeline, which is tracking the error fine but then not stopping the pipeline.
Is there a way, I can track the error and stop the pipeline in such scenarios of connection failure or Data Issue ?
Quick Help will be really appreciated.
Thanks in Advance,