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 / pranay
i don't know y some one ticked my ans as wrong, please give me explanation, n correct ans if i'm not correct. don't tick blindly as no.
Harikrishna, ur ans is correct if it is 4 node configuration and dept_no is key column, read the question properly he asked (1) 2 or 3 node and key column as e_id
(2) 2 or 3 node and key column is dept_id
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of datastage director?
Describe routines in datastage? Enlist various types of routines.
Difference between data warehousing and olap?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the difference between hashfile and sequential file?
What are the components of datastage?
How do you import and export the datastage jobs?
What is data partitioning?
How can one find bugs in job sequence?
how to export or import the jobs in .ISX file
What is the project in datastage?
What is the difference between server job and parallel jobs?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the use of datastage designer?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?