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
How can one find bugs in job sequence?
Can you explain players in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Name the different types of Lookups in Datastage?
What is a datastage job?
Differentiate between datastage and datastage tx?
What is meta stage?
root tree will find which is server job and which is parallel job?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between orabulk and bcp stages?
How do you start developing a datastage project?
what are the errors,warnings in datastage
How you can fix the truncated data error in datastage?
Where the datastage stored his repository?
How many types of views are there in a datastage director?