DSXchange

Hi,

i am getting the below warning while using the change capture stage

Change_Capture_5: When checking operator: Defaulting "Column3" in
transfer from "beforeRec" to "outputRec".

in the before dataset i have two columns (Column1,Column2)
after dataset i have an extra column (Column3)
Key Column :Column1
Value Column :Column2

ramkarthik wrote:Hi,

i am getting the below warning while using the change capture stage

Change_Capture_5: When checking operator: Defaulting "Column3" in
transfer from "beforeRec" to "outputRec".

in the before dataset i have two columns (Column1,Column2)
after dataset i have an extra column (Column3)
Key Column :Column1
Value Column :Column2

Hi,

Have u mapped that (column3) to output of the change capture.. if not do it or else revert with your explanation..

Regards..Naveen.K

There's nowhere for Column3 to get its value from, so DataStage is alerting you to the fact that it is being given its default value.

I hvae mapped Column3 in the output of the change capture stage.I think that it is not the problem of mapping or not mapping the column (Column3) in the output of change capture stage.

In the change(output) dataset i got the same values for column3(as in the after dataset).I am still thrown the warning.

Change_Capture_5: When checking operator: Defaulting "Column3" in
transfer from "beforeRec" to "outputRec".

My Question is :
To fix the warning, should I create one dummy column(Column3) in the before dataset?

ramkarthik wrote:I hvae mapped Column3 in the output of the change capture stage.I think that it is not the problem of mapping or not mapping the column (Column3) in the output of change capture stage.

Well, Mister Expert, if it's not that what is it?

Putting a Column3 on the input link might help, but only if it has something sensible in it.