DSXchange

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??

I honestly don't know off the top of my head but it seems to me it would be simple enough to setup a small test to see.

I would guess it's a Copy, but please go ahead and try it then post the result.

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..

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.

In Change Data Capture it will compare (null to null); It won't say both are different. So you can pass the null col as it is!!

I remeber the same in SCD too.

DS User

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