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
- 10924 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
What are the various kinds of containers available in datastage?
What could be a data source system?
What are the important features of datastage?
What are stage variables and constants?
What is difference between server jobs & parallel jobs?
What is a datastage job?
What is the difference between operational data stage (ods) and data warehouse?
how do u catch bad rows from OCI stage? And what CLI stands for?
what is the use of skid in reporting?
How to convert RGB Value to Hexadecimal values in datastage?
Does datastage support slowly changing dimensions ?
Difference between in process and inter process?
What is oci?
How to manage date conversion in Datastage?
