If U make Dept_no as Key Then data will be as below: node 1 node2 n

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

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

Answer Posted / harikrishna chidrala

If U make Dept_no as Key Then data will be as below:
node 1 node2 node3 node4
1,10 3,20 5,30 6,40
2,10 4,20

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

2267

What is the difference between Datastage 7.5 and 7.0?

1153

Notification Activity

1460

What is a ds designer?

1114

What are the types of jobs we have in datastage?

1123

What is ibm datastage flow designer?

1204

What is the differentiate between data file and descriptor file?

1412

How do you schedule or monitoring the job?

1268

Give an idea of system variables.

1092

What is data partitioning?

1269

Can you explain players in datastage?

1249

Difference between sequential file and data set?

1261

Define project in datastage?

1149

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

which r the connectors used in san?

2231