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
- 9487 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
Differentiate between hash file and sequential file?
Define Job control?
Why do you need stage variables?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Define APT_CONFIG in Datastage?
What is a quality stage in datastage tool?
What is ibm datastage flow designer?
How can we improve the performance in datastage?
What is use Array size in datastage
What is usage analysis in datastage?
Why do we use link partitioner and link collector in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the types of jobs we have in datastage?
What are stage variables?
What is the difference between the local container and shared container?
