error in DS jobs while renaming columns in transformer 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
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

error in DS jobs while renaming columns in transformer stage

Post by arvind_ds »

My DS job design is given below.

seq_file_stage_1 --> transformer_stage -->|
.....................................................................|funnel stage --> DB2 stage
seq_file_stage_2 --> transformer_stage -->|

I am renaming few columns(which are coming from sequential file) in transfomer stage and getting below warning.

TFM_NULL: When checking operator: On output data set 0: Dropping component "DWH_SOURCE_SYSTEM" because of a prior component with the same name.
FNL_INS: When checking operator: Dropping "SOURCE_SYSTEM" in transfer from "inRec" to "outRec".

Although I have disabled RCP at project level still I am getting this error.

Please suggest.
Arvind
maheshsada
Participant
Posts: 69
Joined: Tue Jan 18, 2005 12:15 am

Post by maheshsada »

Check the column name in sequential file, there will be already DWH_SOURCE_SYSTEM column and you are trying to change some other column with the same name.
Also check the partitioning in funnel stage(preserve partitioning should be set)
Post Reply