CDC stage Defaulting values in output

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
lkganta
Participant
Posts: 21
Joined: Wed Feb 08, 2006 4:10 pm

CDC stage Defaulting values in output

Post by lkganta »

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
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Search the forum for "transfer from "beforeRec" to "outputRec""
You are the creator of your destiny - Swami Vivekananda
Post Reply