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 all the types of jobs you developed?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the partitioning techniques available in link partitioner?
What is the difference between account and directory options ?
To see hidden files in LINIX?
What is the difference between server job and parallel jobs?
What is apt_config in datastage?
Why do we use link partitioner and link collector in datastage?
What are the stages in datastage?
CHANGE CAPTURE
What is ibm datastage?
Differentiate between hash file and sequential file?
How do you register plug-ins?
What are datastage sequences?
Have you used Unstructured data?
