warning message while using the change capture stage

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
Svengiyil
Participant
Posts: 25
Joined: Tue May 05, 2009 12:16 am

warning message while using the change capture stage

Post by Svengiyil »

Hi,

I need to compare two files and capture the change,I have two files file1 and file2 as input,passing it to sort stage srt1 and srt2 respectively.
I'm passing the output of the sort stages to a change capture stage Cap_Um.

Under the Options in the chage capture stage , I have chosen

change_Mode=Explict Keys & Values

Under change keys, I have defined all the key columns.
Under the change values , I have considered all the non key columns except one which
is "Transaction_code", as i don't have to consider any changes in this column.

However in the output columns from the change capture i should retain the value for the column Transaction_code from file2.

when i try running the job, its giving a warning message - "Cap_UM: When checking operator: Defaulting "Transaction_code" in transfer from "beforeRec" to "outputRec"".

Can someone explain me on how to resolve this issue?

Thank You,
Svengiyil
Post Reply