Page 1 of 1

Dropping Component warning on the Difference Stage

Posted: Mon Apr 07, 2014 6:09 am
by JPalatianos
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

Posted: Mon Apr 07, 2014 7:25 am
by dsetlteam
Check if RCP is enabled in the job, if yes then disable it and run the job and verify if the warning still exists

Posted: Mon Apr 07, 2014 8:28 am
by JPalatianos
Hi,
RCP is not enabled for this job.

Posted: Mon Apr 07, 2014 4:48 pm
by ray.wurlod
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.

Posted: Tue Apr 08, 2014 1:39 am
by dsetlteam
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 :)