what is the main differences between Lookup, Join and Merge
stages?
Answer Posted / kishore
ANother different is Lookup dont do sorting internally ,
where Merge and Join stage do sorting while data processing .
2. If there are dpluciate records at source , Merge stage
will gives warning but Join stage wont give ,
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is the roundrobin collector?
What are the primary usages of datastage tool?
Describe link sort?
whom do you report?
Define Job control?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the types of containers in datastage?
what is the use of surogate key in datastage
Can you explain players in datastage?
What is active and passive stage?
What are the main features of datastage?
Define meta stage?
What is orabulk stage?
What is the importance of the exception activity in datastage?
Can you explain repository tables in datastage?