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 / harikrishna chidrala

Hi Pranay,

Sorry I got confused with your answer thats Y i messed it up

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Terminate Activity

835


How can we improve the performance in datastage?

647


Is possible to create skid in dim,fact tables?

2187


what is 'reconsideration error' and how can i respond to this error and how to debug this

2115


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

2424






What are the functionalities of link collector?

623


How we can covert server job to a parallel job?

593


explain about citrix scheduling tool in datastage

1808


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

534


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1925


How you can fix the truncated data error in datastage?

1189


What is datastage?

647


how can we create rank using datastage?what is the meaning of rank?

8159


Define data aggregation?

660


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1777