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


Please Help Members By Posting Answers For Below Questions

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027


AGGREGATOR default datatype

931


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2268


What are routines in datastage?

771


What are constraints and derivations?

645






How can you write parallel routines in datastage PX?

615


Can you explain players in datastage?

701


What are the types of hashed files in data stage

640


Describe routines in datastage? Enlist various types of routines.

579


State the difference between an operational datastage and a data warehouse?

602


How do u convert the columns to rows in datastage?

690


Differentiate between odbc and drs stage?

591


Can you filter data in hashed file?

3341


client know skid info?

1631


Can you explain kafka connector?

771