Dropping Component warning on the Difference Stage

JPalatianos · Post by **JPalatianos** » Mon Apr 07, 2014 6:09 am

Hi,
We have a simple job

Row Generator ===> XFM with two output links ===> Difference Stage====>Peek Stage

We gete the follwing two warnings:
diff: When checking operator: Dropping component "diff_key" because of a prior component with the same name.
diff: When checking operator: Dropping component "diff_val" because of a prior component with the same name.

I checked the developer's job and the values of both links going into the Difference Stage from the XFM stage are hard coded:

Link2:
diff_key 1
diff_val "Link 2"
lnk2_ind "2"

Link3:
diff_key 1
diff_val "Link 3"
lnk3_ind "3"

They are using the diff_key as the Difference Keys and for Difference Values:
All non-Key Columns are Valiues = False
Value=diff_val

Thanks - - John

dsetlteam · Post by **dsetlteam** » Mon Apr 07, 2014 7:25 am

Check if RCP is enabled in the job, if yes then disable it and run the job and verify if the warning still exists

JPalatianos · Post by **JPalatianos** » Mon Apr 07, 2014 8:28 am

Hi,
RCP is not enabled for this job.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 07, 2014 4:48 pm

DataStage is telling you that it can't transfer two identically named columns to the output of the stage. You could rename - or make copies of - the columns on one of the input links if you need both in the output.

dsetlteam · Post by **dsetlteam** » Tue Apr 08, 2014 1:39 am

In such a case, I think the best you can do to remove the warning is to introduce a new column (eg: diff_val_new) in the before link that has the same data as diff_val and pass it to the output. The same resolution will hold true for any other column on which the warning is seen.

The problem with the above approach is that there will be an overhead of including new columns on which the warnings are seen, something which is not a best practice