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 datastage?
How to clean the datastage repository?
Triggers,VIEW,Procedures
How a source file is populated?
How the ipc stage work?
What are routines in datastage? Enlist various types of routines.
What is the sortmerge collector?
What is the use of hoursfromtime() function in transformer stage in datastage?
How many types of views are there in a datastage director?
Differentiate between data file and descriptor file?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define ds designer?
How to find value from a column in a dataset?
What are routines in datastage?
What could be a data source system?