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
- 9488 Views
- FIS, I also Faced
- E-Mail Answers
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
Why fact table is in normal form?
What is the roundrobin collector?
What is the difference between datastage and informatica?
What is the difference between Datastage 7.5 and 7.0?
Name the different types of Lookups in Datastage?
What is the project in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is a folder? Difference types of stages?
What is quality stage?
Define oconv () and iconv () functions in datastage?
Explain the importance of surrogate key in data warehousing?
how to implement scd2 in datastage 7.5 with lookup stage
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?
