Difference between JOIN,LOOKUP,MERGE?
- 2 Answers
- 2219 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 data elements?
What is the difference between operational data stage (ods) and data warehouse?
Differentiate between odbc and drs stage?
Is it possible to query a hash file?
how to unlock a locked job in datastage 8.0
types of errors in datastage?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
where the log files or tables can store in DS?
Which warehouse using in your datawarehouse
CHANGE CAPTURE
what is the difference between the active datawarehouse and datawarehouse
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
Teradata 
