i having source like emptable,dept table and combined
purpose using for the join stage but join stage which
partition techq will be prefored?
pls given the ans?
- 2 Answers
- 6415 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / upputuri.vinod
DUDE JOIN STAGE USES THE HASH PARTITION STAGE..
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / san
When ever you want join the two files .. you need to do hash
partition using natural keys both sides. Otherwise the value
related keys will go into different partitions and while
join match will not occur properly.
| Is This Answer Correct ? | 2 Yes | 0 No |
what is a message handler
What is aggtorec restructure operator?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
Why do we use link partitioner and link collector in datastage?
How to display all the duplicate records from the oracle Table?
what is data mapping
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
What is a range lookup?
Difference between sequential file and data set?
How rejected rows are managed in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Teradata 
