Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of datastage director?
What is the difference between validated and compiled in the datastage?
How many areas for files does datastage have?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Difference between data warehousing and olap?
What are the differences between datastage and informatica?
Name the command line functions to import and export the DS jobs?
Can you filter data in hashed file?
what is the use of surogate key in datastage
Define APT_CONFIG in Datastage?
What is the command line function to import and export the ds jobs?
How to clean the datastage repository?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what is flow of project?
Explain Quality stage?
