DSXchange

HI,
Can some one help me to figure out the below CDC stage problem.
I have a datastage job with CDC stage. Basically the CDC stage as two inputs which have exactly the same metadata.
in the CDC stage I am excluding two columns on which the change should not be looked. Inputs have 10 columns in it.

Excluded values :
Exclude Value as : Column3
Exclude Value as : Column4

Change Keys:
Key : Coulmn1
Key : Coulmn2


Options that are set :

Change Mode : Explicit Keys, All values
Drop output for Copy : False
Drop output for Delete : False
Drop output for Edit : False
Drop output for Insert : False
Log Statistics : False


Problem : After the process, excluded value columns, that is column3(number) and column4(char) are defaulted to zero and spaces in the CDC output.
But I am expecting the values to be carried and not any changes to the data.

Warning That I am receiving is :

cdcTCECPO_XCP: When checking operator: Defaulting "column3" in transfer from "beforeRec" to "outputRec". [api/transfer_rep.C:1826]
cdcTCECPO_XCP: When checking operator: Defaulting "column4" in transfer from "beforeRec" to "outputRec". [api/transfer_rep.C:1826]

Thank you for your help in advance.

- lkganta

Search the forum for "transfer from "beforeRec" to "outputRec""