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
- 11003 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
State the difference between an operational datastage and a data warehouse?
How to read multiple files using a single datastage job if files have the same metadata?
Differentiate between datastage and datastage tx?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Define Routines and their types?
What are the various kinds of containers available in datastage?
What is difference between server jobs & parallel jobs?
Define meta stage?
what are the errors,warnings in datastage
What is the use of hoursfromtime() function in transformer stage in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is a merge?
What is a folder? Difference types of stages?
Define APT_CONFIG in Datastage?
