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
- 10753 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / pranay
Consider you r having two nodes node 1 and node and u
selected e_id as hash key then
for two nodes for three nodes
node 1 node 2 node 1 node 2 node 3
1,10 2,10 1,10 2,10 3,20
3,20 4,20 4,20 5,30 6,40
5,30 6,40
if u selected dept_no as hash id then
for two node for three node
node 1 node 2 node1 node2 node3
1,10 3,20 1,10 3,20 5,30
2,10 4,20 2,10 4,20
5,30 6,40 6,40
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
whom do you report?
What is the difference between datastage and informatica?
What are transforms and what is the differenece between routines and transforms?
What is ibm datastage flow designer?
Explain entity, attribute and relationship in datastage?
what is repositery?
how do u catch bad rows from OCI stage? And what CLI stands for?
how to implement scd2 in datastage 7.5 with lookup stage
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How to manage date conversion in Datastage?
how to write server Routine coding?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the importance of the exception activity in datastage?
What is difference between join, merge and lookup stage?
What is the difference between odbc and drs stage?
