Problem in Change capture stage

ketanshah123 · Post by **ketanshah123** » Tue May 20, 2008 3:08 am

In my before and after datasets have same identical data still change capture stage showing some records as edit ?

what is the reason for same?

It could have anything to do with having NULL values in so many of the key columns ? but there is absolutely nothing in the DataStage or Orchestrate documentation on the Change Capture stage that discusses NULL values.

keshav0307 · Post by **keshav0307** » Tue May 20, 2008 7:01 pm

the columns are CASE sensitive or insensitive?
do you have any char, varchar coulmn in keys and values??
what is the $APT_PAD_CHAR??

martind · Post by **martind** » Wed May 28, 2008 10:36 pm

Are you comparing a Null value with an empty string at some point? This would result in an Edit.