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 |
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
how can we join one oracle & flat files ?
when will you go for dataset and fileset?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
Difference in the implementation of lookup and join stages,in joining two tables?
What is the difference between an operational datastage and a data warehouse?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the sortmerge collector?