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
- 9027 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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is ibm datastage flow designer?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How many areas for files does datastage have?
What is the difference between an operational datastage and a data warehouse?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Why do we use link partitioner and link collector in datastage?
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.
What is the difference between Datastage 7.5 and 7.0?
What are the different layers in the information server architecture?
How and where you used hash file?
Differentiate between datastage and informatica?
Have you used Unstructured data?
what is repositery?
Does datastage support slowly changing dimensions ?
