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 |
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
How to perform incremental load in datastage?
How to move data set from one server to other?what are the steps to follow to do this?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
What is the use of Row generator stage?
Name the command line functions to import and export the DS jobs?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
Difference between the Sequence and Sequencer in DS?
what are fact tables and dimension tables? give example assuming one table.
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.