Source always wins
784624Sep 25 2010 — edited Oct 19 2010
We are doing the initial load through a utility and we are not sure we have all data from the source.
We want to have the following rule when the change capture happens.
1) Update of a record when the primary keys are not present in the target database -> Convert the update statment to INsert statment(Need to have all the columns)
2) Delete a record when the primary keys are not present in the target - Ignore the statement.
3) Insert of a record when the primary keys are present in the target. Overlay the records (Need to touch all columns in the target)
Handlecollisions parameter will overlay the existing records but ignores the update when the keys are not present in the target.
Appreciate your suggestions.