DSXchange

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.

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.

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

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.