Interested to Buy Any Domain ? << Click Here >> for more details...
what is the best stage in datastage parller jobs to use full
out join and why
- 5 Answers
- 15725 Views
- Virtusa, I also Faced
- E-Mail Answers
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 |
What is orabulk stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how do u reduce warnings
What is a quality stage in datastage tool?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
can we use sequential file as a lookup
Explain datastage architecture?
how to define satge variables in transformer stage
How a routine is called in datastage job?
what is the use of surogate key in datastage
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
How many Nodes configuration file you used in your last project?
Teradata 
