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
I have a few records just I want to store data in to targets cycling way how?
What are the some differences between 7.x and 8.x version of datastage?
How do you import and export data into datastage?
what are the errors,warnings in datastage
How we can covert server job to a parallel job?
How to implement complex jobs in data stage?
What are the stages in datastage?
What are the types of hashed files in data stage
how can we create rank using datastage?what is the meaning of rank?
sed,awk,head
How a routine is called in datastage job?
What is the precedence of stage variables,derivations, and constraints?
Differentiate between datastage and datastage tx?
What is the purpose of pivot stage?
What is the difference between the local container and shared container?
