Well The basic idea is: Same key column values are given to the same node.

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

Question Posted / shar

5 Answers
11159 Views
FIS, I also Faced
E-Mail Answers

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

Define APT_CONFIG in Datastage?

1135

Can you filter data in hashed file?

3826

Explain entity, attribute and relationship in datastage?

1156

Triggers,VIEW,Procedures

1266

Is it possible to query a hash file?

2060

Differentiate between datastage and informatica?

1250

Which warehouse using in your datawarehouse

2234

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3182

what is the difference between == and eq in UNIX shell scripting?

1558

What are routines in datastage? Enlist various types of routines.

1154

Where do the datastage jobs get stored?

1269

Enlist various types of routines in datastage.

1328

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

980

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2780

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1350