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


Please Help Members By Posting Answers For Below Questions

What are the different options associated with dsjob command?

901


Difference between data warehousing and olap?

631


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2400


Define repository tables in datastage?

674


Give an idea of system variables.

562






What are the areas of application?

631


How do you import and export the datastage jobs?

713


What are constraints and derivations?

621


Describe routines in datastage? Enlist various types of routines.

560


What all the types of jobs you developed?

646


What are the partitioning techniques available in link partitioner?

1722


How do you register plug-ins?

578


Difference between sequential file and data set?

617


how many rows sorted in sort stage by default in server jobs

3532


Define oconv () and iconv () functions in datastage?

854