Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 are the third party tools you used in your project?

1 Answers   IBM,


tell me abt Datastage trigger?

1 Answers   HP, IBM,


What are the functionalities of link partitioner?

0 Answers  


what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,


How to clean the datastage repository?

0 Answers  






What is the importance of the exception activity in datastage?

0 Answers  


Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,


How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  


What are the primary usages of datastage tool?

0 Answers  


What are the different options associated with dsjob command?

0 Answers  


How many input links can you give to a Transformer stage?

6 Answers  






Categories