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?
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 |
Can we use target hash file as a lookup ?
how can i abort the job if i get more than 100 errors in job log?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
how CAN we remove duplicates in dataset?
Differentiate between data file and descriptor file?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
How do u call shellscript/Batch file from DS?
What is the process of killing a job in datastage?
What is a delta record? How you will read it?
What is meta stage?
what is data mapping
How to find value from a column in a dataset?