Difference between JOIN,LOOKUP,MERGE?
- 2 Answers
- 2214 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 are the different layers in the information server architecture?
how to get the unique records on multiple columns by using sequential file stage only
What is ds designer?
What is a folder? Difference types of stages?
what is a force compile
Differentiate between data file and descriptor file?
Why do we use link partitioner and link collector in datastage?
Difference between server jobs & parallel jobs?
HOW CAN WE SEE THE DATA IN DATASET?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
1)Source file contains one record, I want 100 records in target file.
What is PX?
Teradata 
