DSXchange

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.

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

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