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
- 6149 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 |
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
What all the types of jobs you developed?
How to read the length of word in unix?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How the ipc stage work?
why do we need a datawarehouse when we have databases to store data?
Why fact table is in normal form?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are some different alternative commands associated with "dsjob"?
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
Differentiate between data file and descriptor file?
Explain the importance of surrogate key in data warehousing?
Teradata 
