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
- 9489 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 a datastage macro?
Explain the situation where you have applied SCD in your project?
sed,awk,head
How to RD using transformer?
How do you register plug-ins?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How we can covert server job to a parallel job?
what is flow of project?
Explain how a source file is populated?
describe the Steps to confiure a Qlogic switch
Whats difference betweeen operational data stage (ods) and data warehouse?
What can we do with datastage director?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the different types of lookups in datastage?
Can you explain players in datastage?
