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
What is the purpose of interprocessor stage in server jobs?
Can you explain repository tables in datastage?
Nls stands for what in datastage?
What are the primary usages of datastage tool?
What is the difference between informatica and datastage?
What are sequencers?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Define project in datastage?
What is the sortmerge collector?
Differentiate between Join, Merge and Lookup stage?
Define Routines and their types?
What are the functionalities of link collector?
Explain the importance of surrogate key in data warehousing?
Where do you see different stages in the designer?
How you Implemented SCD Type 1 & Type 2 in your project?