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
How does look-up and join behave under simmilar Scenerio?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 148
- Joined: Thu Apr 10, 2008 12:47 am
Re: How does look-up and join behave under simmilar Scenerio
its based on what are the options u are choosing in Lookup stage and join types...devesh_ssingh wrote: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