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 / 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 are the different options associated with dsjob command?
Difference between data warehousing and olap?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Define repository tables in datastage?
Give an idea of system variables.
What are the areas of application?
How do you import and export the datastage jobs?
What are constraints and derivations?
Describe routines in datastage? Enlist various types of routines.
What all the types of jobs you developed?
What are the partitioning techniques available in link partitioner?
How do you register plug-ins?
Difference between sequential file and data set?
how many rows sorted in sort stage by default in server jobs
Define oconv () and iconv () functions in datastage?