what is the best stage in datastage parller jobs to use full
out join and why
Answers were Sorted based on User's Feedback
Answer / vinay kumar
join stage is the best,why means data getting from buffer
area.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / bharath
Hi,
Join stage is best 4 full outer join bcoz
lookup is RAM intensive where as join uses less memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
join is the best because join uses the less memory compare with lookup
| Is This Answer Correct ? | 0 Yes | 0 No |
i want job aborted after some records are loaded into output by using only sequential stage and dataset
Define Routines and their types?
How to read the length of word in unix?
can any one tell me how to install datastage 8.1 in windows xp with wizard
On which interface you will be working as a developer?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
Describe the main features of datastage?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
describe the Steps to confiure a Qlogic switch
What are the types of hashed files in data stage
Difference between server jobs & parallel jobs?
Describe stream connector?