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
- 11160 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
what is ds administrator used for?
What are the benefits of datastage?
What are iconv and oconv?
How can we improve the performance in datastage?
How you can fix the truncated data error in datastage?
What is process model?
What is the roundrobin collector?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
project Steps,hits, Project level HArd things,Solved methods?
What all the types of jobs you developed?
What is the purpose of pivot stage and types of containers in datastage
What is a folder? Difference types of stages?
Which algorithm you used for your hashfile?
How do you import and export data into datastage?
What are transforms and what is the differenece between routines and transforms?
