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
- 15793 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 |
On which interface you will be working as a developer?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
source file contains 100 records, i want 10 records in target file how it possible in datastage
What is the difference between account and directory options ?
What are the types of views in datastage director?
What are the features of datastage flow designer?
count number of deptno in a emp table?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
what is the function in Transformer stage can act as Rank function in Oracle
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
how do u reduce warnings
Teradata 
