DSXchange

Hi
I'm getting this warning...

Join: When checking operator: Dropping component "tab_name" because of prior component with same name

what does it mean???

Hi Vivek
It's simple and straight forward! You are having a column (non-key column) in both the datasources for the join stage. Depends on your link ordering it picks the column from the driving datasource and dropping the other column with the same name from the other datasource. Just look into that and your warning is solved.

But no,
I've renamed the columns that are not part of the key in the second stage as c_columnname

vivek - in which stage did you rename the columns?
(hint - some stage won't let you do that plus think of column propagation)

This is how my job is...
left_table ----\
left outer join---
right_table ---/

bath tables have 29 columns (same columns)
Only 1 column is the key - parent_id
I've renamed the columns (except parent_id) in the right_table within a transformer as 'c_'columnName

Is there anything else I should do???

vivek - what does your transformer output have to say about "column propagation"? I think you have left it turned on, thus the changed name is being overridden.

are you referring to runtime column propagation?
if yes, it is turned off in the administrator for this project.
if no, how do i do that?

Vivek - go into your designer and open up your transformer stage.
Top left corner you have a hand pointing onto a sheet of paper, click on that.
Then click on the Outputs tab.
Then click on the link you want to look at and on the General tabl.
Bottom right has a check box for Column Propagation. This should be off.

It is Ticked and Disabled!
How do I enable it so that I can UnTick it???

Now I'm confused. It should be unticked. Maybe someone else might be able to help here.

Thanks a lot anyways.
If I figure it out, I'll let you know...

You may turned on RCP in the administrator for this project first. And then unticked in the stage's RCP.