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

HOw Hash Partion Works

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

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

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

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

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

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

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

More Data Stage Interview Questions

What are the third party tools you used in your project?

tell me abt Datastage trigger?

What are the functionalities of link partitioner?

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

How to clean the datastage repository?

What is the importance of the exception activity in datastage?

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?

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?

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

What are the primary usages of datastage tool?

What are the different options associated with dsjob command?

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

Categories