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
- 10754 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / shar
Well The basic idea is:
Same key column values are given to the same node.
Hence
1.(e_id)
node1 node2 node1 node2 node3
1,10 2,10 1,10 2,10 3,20
3,20 4,20 4,20 5,30 6,40
5,30 6,40
2. (dept_no)
node1 node2 node1 node2 node3
1,10 3,20 1,10 3,20 5,30
2,10 4,20 2,10 4,20 6,40
5,30 6,40
(This is where pranay went wrong 6,40 will go to node3
instead of node1.)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between account and directory options ?
root tree will find which is server job and which is parallel job?
What is difference between join, merge and lookup stage?
How many types of stage?
What are some different alternative commands associated with "dsjob"?
Describe link sort?
Can you filter data in hashed file?
What is the difference between an operational datastage and a data warehouse?
What is the difference between datastage and datastage tx?
What is the roundrobin collector?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is aggtorec restructure operator?
What are the different layers in the information server architecture?
How do you schedule or monitoring the job?
Highlight the main features of datastage?
