What are the prerequisites for join stage
Answers were Sorted based on User's Feedback
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 |
How to perform incremental load in datastage?
Which commands are used to import and export the datastage jobs?
what is repositery?
how to define satge variables in transformer stage
In merge stage can we update the values?
how can or from where we can get reference data in scd type2 implementation?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
How do you run datastage job from the command line?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
What is the difference between SQl Loader and OCI in datastage?
How to move data set from one server to other?what are the steps to follow to do this?