Join Stage

karthi_gana · Post by **karthi_gana** » Thu Aug 30, 2012 4:03 am

All,

My job design is as below

file1 -->

File2 --> Join (Left outer join = File 3) --> Remove duplicates --> File

File3 -->

I have added new column in both file1 & file 2. But it is not at all displaying in the Join stage "Mapping" - Output table. why?

Even I re-compiled the job. But it is not coming.

ShaneMuir · Post by **ShaneMuir** » Thu Aug 30, 2012 4:38 am

At a guess - Do you have the same column name in all the files?

What is your left link? If multiple inputs have the same column names only the column from the left link is available for mapping.

ArndW · Post by **ArndW** » Thu Aug 30, 2012 5:24 am

Not only same name, but same data types, lengths & nullability.

karthi_gana · Post by **karthi_gana** » Thu Aug 30, 2012 6:02 am

ShaneMuir wrote:What is your left link? If multiple inputs have the same column names only the column from the left link is available for mapping.

You are right. I used the same name

After changing the name, I can see it.