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
- 5 Answers
- 10927 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain Quality stage?
How do you generate sequence number in datastage?
Can you explain tagbatch restructure operator?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Can you explain players in datastage?
which r the connectors used in san?
What is the precedence of stage variables,derivations, and constraints?
Explain the situation where you have applied SCD in your project?
What are the areas of application?
CHANGE CAPTURE
Name the command line functions to import and export the DS jobs?
Define Routines and their types?
Differentiate between Join, Merge and Lookup stage?
To see hidden files in LINIX?
