Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shar
1.Inputs as left right and intermediate links(files).
2.can do left outer,right outer,inner join and full outer join
3.N inputs for left,right and inner but 2 inputs for full outer.
4.Inputs should be sorted and partitioned for better
performance.
5.Removing duplicates is optional as join operation is
highly optimized which sequential and less i/o and less page
faults.
6.Memory requirements are comparatively less than Lookup stage.
7.In join key columns names should be same in primary and
secondary datasets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Datastage 7.5 and 7.0?
how to sort two columns in single job in datastage.
Is possible to create skid in dim,fact tables?
How to read the length of word in unix?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Name the third party tools that can be used in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
Is it possible to query a hash file?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to manage date conversion in Datastage?
In Datastage, how you can fix the truncated data error?
Can you explain tagbatch restructure operator?
What all the types of jobs you developed?
Define ds designer?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
