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
- 6251 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 |
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How do y read Sequential file from job control?
What are the components of ascential data stage?
What are the types of views in datastage director?
How to move data set from one server to other?what are the steps to follow to do this?
How do you schedule or monitoring the job?
What is the function in Transformer stage can act as Rank Function in oracle
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
how to capture rejected data by using join stage not for lookup stage. please let me know
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is active and passive stage?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
Teradata 
