nulls in value columns(CDC)

srinivas.nettalam · Post by **srinivas.nettalam** » Mon Dec 12, 2011 6:39 am

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

chulett · Post by **chulett** » Mon Dec 12, 2011 7:00 am

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.

qt_ky · Post by **qt_ky** » Mon Dec 12, 2011 11:05 am

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

kamtammystuff · Post by **kamtammystuff** » Mon Dec 12, 2011 10:07 pm

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

kwwilliams · Post by **kwwilliams** » Mon Dec 12, 2011 10:28 pm

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.

SURA · Post by **SURA** » Mon Dec 12, 2011 10:32 pm

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 · Post by **kamtammystuff** » Mon Dec 12, 2011 10:37 pm

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

DSXchange

nulls in value columns(CDC)

nulls in value columns(CDC)

Re: nulls in value columns(CDC)