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 are the features of datastage flow designer?
What is the use of datastage director?
How to perform incremental load in datastage?
To see hidden files in LINIX?
Explain the importance of surrogate key in data warehousing?
What are the processing stages?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is use Array size in datastage
What is the process of killing a job in datastage?
What is aggtorec restructure operator?
What is a ds designer?
What are the types of containers and how to create them?
What is process model?
How to manage date conversion in Datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?