Difference between JOIN,LOOKUP,MERGE?
- 2 Answers
- 2407 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 |
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
What is Cleanup Resources and when do you use it?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
what is materialized view used datastage?
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
What is the process of killing a job in datastage?
how to handle null values in sequential file?
how to sort two columns in single job in datastage.
Highlight the main features of datastage?
What are the difference types of stages?
Teradata 
