Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6924 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 |
How to move data set from one server to other?what are the steps to follow to do this?
Differentiate between data file and descriptor file?
What is the difference between account and directory options ?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
How can you write parallel routines in datastage PX?
How can we do null handling in sequential files
when we will use connected Lookup & Unconnected Lookup
Can you explain tagbatch restructure operator?
Can you explain players in datastage?
table actions available in oracle connector?
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?
plz tell me some dimentional and fact table names in banking project?
Teradata 
