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
whom do you report?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the benefits of datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Terminate Activity
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the different common services in datastage?
How many types of sorting methods are available in datastage?
What can we do with datastage director?
What is meta stage?
What is a ds designer?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the main features of datastage?
State the difference between an operational datastage and a data warehouse?
What are iconv and oconv?