Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Answers were Sorted based on User's Feedback



HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please g..

Answer / 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

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please g..

Answer / pranay

Consider you r having two nodes node 1 and node and u
selected e_id as hash key then
for two nodes for three nodes
node 1 node 2 node 1 node 2 node 3
1,10 2,10 1,10 2,10 3,20
3,20 4,20 4,20 5,30 6,40
5,30 6,40

if u selected dept_no as hash id then
for two node for three node
node 1 node 2 node1 node2 node3
1,10 3,20 1,10 3,20 5,30
2,10 4,20 2,10 4,20
5,30 6,40 6,40

Is This Answer Correct ?    6 Yes 6 No

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please g..

Answer / pranay

i don't know y some one ticked my ans as wrong, please give me explanation, n correct ans if i'm not correct. don't tick blindly as no.

Harikrishna, ur ans is correct if it is 4 node configuration and dept_no is key column, read the question properly he asked (1) 2 or 3 node and key column as e_id
(2) 2 or 3 node and key column is dept_id

Is This Answer Correct ?    0 Yes 0 No

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please g..

Answer / 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

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please g..

Answer / 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

More Data Stage Interview Questions

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  


WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,


What is active and passive stage?

0 Answers  


What are operators in datastage?

1 Answers  


If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,


What are the different common services in datastage?

0 Answers  


what is mapping lookup

1 Answers  


I have 100 records how can I load at a time from the single time

1 Answers  


How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,


What are stage variables and constants?

0 Answers  


What are stage variables?

0 Answers  


how can u connect the client system directly at any time?

1 Answers   IBM,


Categories