Interested to Buy Any Domain ? << Click Here >> for more details...
HOw Hash Partion Works
Thank you in Advance
i have doubts on Hash Partion TEch Could please give me the
clear understandable notation
example
e_id,dept_no
1,10
2,10
3,20
4,20
5,30
6,40
i have TWo Nodes/Three Nodes
My questions are:
1).if i select hash key as e_id how Hash partion will
distribute the data in to two NOdes/three NOdes
2).if i select hash key as dept_no how Hash partion will
distribute the data in to two NOdes/three NOdes
sivakumar.katta7@gmail.com
- 5 Answers
- 10926 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / harikrishna chidrala
If U make Dept_no as Key Then data will be as below:
node 1 node2 node3 node4
1,10 3,20 5,30 6,40
2,10 4,20
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Enlist various types of routines in datastage.
How complex jobs are implemented in datstage to improve performance?
What is use Array size in datastage
What is apt_config in datastage?
What is oci?
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?
What are stage variables, derivations and constants?
What are stage variables and constants?
What are system variables and sequencers in datastage
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
root tree will find which is server job and which is parallel job?
What are the enhancements made in datastage 7.5 compare with 7.0?
Differentiate between odbc and drs stage?
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
In Datastage, how you can fix the truncated data error?
