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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is oci?
What can we do with datastage director?
Why fact table is in normal form?
client know skid info?
How to implement complex jobs in data stage?
Notification Activity
What are the some differences between 7.x and 8.x version of datastage?
Explain the situation where you have applied SCD in your project?
What is the difference between account and directory options ?
Have you have ever worked in unix environment and why it is useful in datastage?
what is ds administrator used for?
What are some different alternative commands associated with "dsjob"?
What is staging variable?
Describe stream connector?
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...
