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?
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
How do you run datastage job from the command line?
What is the importance of the exception activity in datastage?
How do you import and export the datastage jobs?
Which algorithm you used for your hashfile?
which r the connectors used in san?
What are the functionalities of link collector?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Define meta stage?
State the difference between an operational datastage and a data warehouse?
What are the some differences between 7.x and 8.x version of datastage?
Can you explain engine tier in information server?
Whats difference betweeen operational data stage (ods) and data warehouse?
How many types of hash files are there?
How to perform incremental load in datastage?
What is ibm datastage flow designer?