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
- 9006 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
what is the use of surogate key in datastage
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define repository tables in datastage?
Can you explain link buffering?
Where do the datastage jobs get stored?
What is a merge in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the sortmerge collector?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the method of removing duplicates, without the remove duplicate stage?
What are data elements?
root tree will find which is server job and which is parallel job?
How rejected rows are managed in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
