Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between JOIN,LOOKUP,MERGE?
- 2 Answers
- 3108 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh pandi
1.if a source have huge volume of datea, then that time we have to use join, or merge stage
2.if you want to filter the unmatched record from reference files, then we should use merge stage only
3.join stage can have 'n' number of input link(1 left link 1right link other links called intermediate link) but only one output link...
Merge stage cane have 'n' no of input link (1 master link n update link) and one output link And equal no of reject link as same as update link
Look up stage can have n number of input link and 1 output link and one reject link
4.join we can do all join operation inner, left outer, right outer, full outer but in merge and lookup we can only do a inner join and left outer join
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajesh pandi
1.if a source have huge volume of datea, then that time we have to use join, or merge stage
2.if you want to filter the unmatched record from reference files, then we should use merge stage only
3.join stage can have 'n' number of input link(1 left link 1right link other links called intermediate link) but only one output link...
Merge stage cane have 'n' no of input link (1 master link n update link) and one output link And equal no of reject link as same as update link
Look up stage can have n number of input link and 1 output link and one reject link
4.join we can do all join operation inner, left outer, right outer, full outer but in merge and lookup we can only do a inner join and left outer join
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the default padding character?
What is a datastage job?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
I have a few records just I want to store data in to targets cycling way how?
Define Merge?
how to define satge variables in transformer stage
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
what is the diff between sequential file and fileset stages?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
what is hash file
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Differentiate between operational datastage (ods) and data warehouse?
Teradata 
