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

What is a folder? Difference types of stages?

0 Answers  


Define project in datastage?

0 Answers  


j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,


What are the differences between datastage and informatica?

0 Answers  


Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,


What are datastage sequences?

0 Answers  


How to create user defined environment varibale(parameter)?

1 Answers   TCS,


I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,


My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,


IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  


what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,


Terminate Activity

0 Answers   CTS,


Categories