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 difference between server job and parallel jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what is use of SDR function?
What are transforms and what is the differenece between routines and transforms?
What are the important features of datastage?
What is orabulk stage?
Can we use target hash file as a lookup ?
sed,awk,head
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the main differences you have observed between 7.x and 8.x version of datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Can you explain engine tier in information server?