How does look-up and join behave under simmilar Scenerio?

[devesh_ssingh]

Hi all,

I got one doubt

if we are joining two file one have non-duplicate value and other file have duplicate values so does output carried duplicate records?
aslo if we use look for same scenerio the how will output respond?
does it carry duplicated value or not if yes then why and if not then why.

file X have rows like 1,2,3,4,5 which is input file
File Y have rows like 1,1,1,1,1 which is reference in case of look up.

what should output Z will give in case of look-up and join?
and how?

Many many thanks in advance,

Devesh

[mail2hfz]

Develop a simple test job with your questions then you can identify the differences.

[dsedi]

Hi all,

I got one doubt
.
.
what should output Z will give in case of look-up and join?
and how?

Many many thanks in advance,

Devesh

its based on what are the options u are choosing in Lookup stage and join types...