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
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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the different type of jobs in datastage?
Can you filter data in hashed file?
what is ds administrator used for?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
State the difference between an operational datastage and a data warehouse?
What is a folder? Difference types of stages?
Can you explain players in datastage?
Differentiate between Join, Merge and Lookup stage?
What are the partitioning techniques available in link partitioner?
What is the difference between an operational datastage and a data warehouse?
What are the processing stages?
What are the features of datastage flow designer?
Difference between in process and inter process?
What is use Array size in datastage