Hi,
Would someone let me know how does CDC work in case where both before and after links have nulls in change value column for an existing key value?Will it be an update or copy??
A null value on both the before and after record will be a copy. The stage would be fairly useless if everytime a column had to null values it declared it an update. I've seen this in numerous jobs in the past.
kamtammystuff wrote:I guess it would treat it as a update record if any one of the link has a null value in it , anyways simple testing is the best way to know..
It will treat as a update ecord only if only one has a null value and copy if both are nulls