what is the best stage in datastage parller jobs to use full
out join and why

Answer Posted / swetha

use the join stage rather than using lookup and merge stages. join stage supports all the joins like inner join,leftouter join,right outer join,full outer join
lookup supports only inner,leftouter only

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of interprocessor stage in server jobs?

1739


Can you explain repository tables in datastage?

915


Nls stands for what in datastage?

738


What are the primary usages of datastage tool?

631


What is the difference between informatica and datastage?

666






What are sequencers?

626


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1927


Define project in datastage?

680


What is the sortmerge collector?

676


Differentiate between Join, Merge and Lookup stage?

658


Define Routines and their types?

633


What are the functionalities of link collector?

639


Explain the importance of surrogate key in data warehousing?

725


Where do you see different stages in the designer?

648


How you Implemented SCD Type 1 & Type 2 in your project?

3705