DSXchange

In my job there is change capture stage.The i/p is two source file.Now the there are 2 targets. One target captures the new records and the other one captures the same records.
Now in the change capture stage the option Change Mode="Explicit Keys & Values" has been set and the change column name in Change Values option has not been mentioned explicitly as it is not capturing the updated records.

The warning I am getting in log is When checking operator: Defaulting "ACCOUNT_ID" in transfer from "beforeRec" to "outputRec"."

All the columns names except the key columns are coming in the log.

Now the job is getting aborted as no of warnings is more than 50 in project level which I can't change.

I can't change the job design also as i don't have access to do that.

So how can I eliminate this warning?
Please suggest.

Thanks
Shaonli

shaonli wrote:In my job there is change capture stage.The i/p is two source file.Now the there are 2 targets. One target captures the new records and the other one captures the same records.
Now in the change capture stage the option Change Mode="Explicit Keys & Values" has been set and the change column name in Change Values option has not been mentioned explicitly as it is not capturing the updated records.

The warning I am getting in log is When checking operator: Defaulting "ACCOUNT_ID" in transfer from "beforeRec" to "outputRec"."

All the columns names except the key columns are coming in the log.

Now the job is getting aborted as no of warnings is more than 50 in project level which I can't change.

I can't change the job design also as i don't have access to do that.

So how can I eliminate this warning?
Please suggest.

Thanks
Shaonli

From what you have posted I assume that you just one to get the new records(when a record with a new key value is added) and the old records(even if they have been updated).

For this you can use either the explicity keys and values like you are using. But if you do that you need to <b>explicitly</b> define the keys and values(Even when you don't want to track updates) which you are not doing.

So, you have two options now. Either set the Change mode to Explicit Keys All Values, or add all the value columns to the Change capture stage like you've done for keys. If you can't change the design, the only option you have is to suppress the warning. But, you'll still have bad data in the output.

The warning might be because of meta data for this column being different for the Before and After link. Suppress the warning from the director log.

Why not have just one output, and direct the rows (in a Transformer, Filter or Switch stage) based on the Change Capture result?

Thanks for the inputs.
I don't have access to change the jobs.So there is no option other than supressing the warnings in the log.

Thanks
Shaonli