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
CDC stage Defaulting values in output
Moderators: chulett, rschirm, roy