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
Answer Posted / harikrishna chidrala
Hi Pranay,
Sorry I got confused with your answer thats Y i messed it up
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What steps should be taken to improve Datastage jobs?
How do you import and export data into datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How many areas for files does datastage have?
client know skid info?
how to write server Routine coding?
How the ipc stage work?
How many types of sorting methods are available in datastage?
Where do you see different stages in the designer?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
in oracle target stage when we use load option and when we use upsert option?
how to sort two columns in single job in datastage.
What are the primary usages of datastage tool?
What is the purpose of interprocessor stage in server jobs?
Explain datastage architecture?