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

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
10761 Views
FIS, I also Faced
E-Mail Answers

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

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

954

Why do we use exception activity in Datastage?

1231

What is the use of datastage designer?

1090

options available in sequence job to run,validate?

1260

What are the difference types of stages?

1136

Explain usage analysis in datastage?

1098

How many Key we can define in remove duplicate stage?

1317

Can you highlight the main features of ibm infosphere information server?

1047

Define orabulk and bcp stages?

1069

What is the difference between account and directory options ?

1116

How do you remove duplicate values in datastage?

1099

What are stage variables and constants?

1098

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

3935

How we can covert server job to a parallel job?

1064

How do you import and export the datastage jobs?

1113