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
- 16123 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 |
Whats difference betweeen operational data stage (ods) and data warehouse?
Wat is isolation level and when do u use them?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
what is a message handler
How many number of reject links merge stage can have?
Give an idea of system variables.
what is the definitions for Datawarehose and Datamart?
Can you filter data in hashed file?
What are stage variables, derivations and constants?
source file is having 5 records while moving into target it want to be 10 records
what is 'reconsideration error' and how can i respond to this error and how to debug this
Can we use Round Robin for aggregator?is there any benefit underlying?
Teradata 
