Join: When checking operator: Dropping component

vivek_rs · Post by **vivek_rs** » Fri Feb 25, 2005 5:25 am

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???

vigneshra · Post by **vigneshra** » Fri Feb 25, 2005 6:59 am

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.

vivek_rs · Post by **vivek_rs** » Fri Feb 25, 2005 7:15 am

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

ArndW · Post by **ArndW** » Fri Feb 25, 2005 8:08 am

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

vivek_rs · Post by **vivek_rs** » Fri Feb 25, 2005 8:20 am

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???

ArndW · Post by **ArndW** » Fri Feb 25, 2005 8:24 am

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.

vivek_rs · Post by **vivek_rs** » Fri Feb 25, 2005 8:32 am

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?

ArndW · Post by **ArndW** » Fri Feb 25, 2005 8:39 am

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.

vivek_rs · Post by **vivek_rs** » Fri Feb 25, 2005 8:42 am

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

ArndW · Post by **ArndW** » Fri Feb 25, 2005 8:44 am

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

vivek_rs · Post by **vivek_rs** » Fri Feb 25, 2005 9:09 am

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

benny.lbs · Post by **benny.lbs** » Sun Feb 27, 2005 6:20 am

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