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
sed,awk,head
State the difference between an operational datastage and a data warehouse?
What are the components of ascential data stage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
what is the use of materialized view?
Where do the datastage jobs get stored?
What is a folder? Difference types of stages?
What are the different plug-ins stages used in your projects?
Differentiate between Join, Merge and Lookup stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the main features of datastage?
What are orabulk and bcp stages?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Can we use target hash file as a lookup ?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance