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
10752 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

What are the steps required to kill the job in Datastage?

1150

How rejected rows are managed in datastage?

1449

What are the different layers in the information server architecture?

1079

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3736

Define data aggregation?

1048

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2167

What are the functionalities of link collector?

1038

What are the different common services in datastage?

1216

What is the use of datastage director?

975

explain about citrix scheduling tool in datastage

2382

What is difference between symmetric multiprocessing and massive parallel processing?

1084

What are the types of views in datastage director?

1720

options available in sequence job to run,validate?

1260

What is the purpose of interprocessor stage in server jobs?

2172

What a datastage macro?

1007