Which type of joins Merge stage can support?

Answer Posted / nagaraz

MERGE STAGE CAN SUPPORT INNER JOINT AND LEFT OUTER JOINT

Is This Answer Correct ?    32 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can covert server job to a parallel job?

599


What is the roundrobin collector?

642


Why do we use exception activity in Datastage?

729


What is difference between join, merge and lookup stage?

639


Explain how a source file is populated?

767






Define Routines and their types?

624


How many types of sorting methods are available in datastage?

636


What is the precedence of stage variables,derivations, and constraints?

603


How can we improve the performance in datastage?

654


Difference between ‘validated ok’ and ‘compiled’ in data stage?

679


what is the use of surogate key in datastage

1824


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

611


What is the difference between in process and inter process?

674


What is quality stage?

575


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2431