How does look-up and join behave under simmilar Scenerio?
Posted: Mon May 04, 2009 7:42 am
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
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