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
- 6829 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does datastage support slowly changing dimensions ?
What are the various kinds of the hash file?
How to read the length of word in unix?
What are the types of containers in datastage?
Define Merge?
What are the important features of datastage?
What is difference between server jobs & parallel jobs?
sed,awk,head
What are system variables and sequencers in datastage
how to implement scd2 in datastage 7.5 with lookup stage
How do you run datastage job from the command line?
What are the main features of datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
