Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11151 Views
- FIS, I also Faced
- E-Mail Answers
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
Notification Activity
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is "fatal error/rdbms code 3996" error?
Why fact table is in normal form?
What is the purpose of interprocessor stage in server jobs?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the repository tables in datastage?
What is the command line function to import and export the ds jobs?
Define Routines and their types?
How do you schedule or monitoring the job?
What is a merge?
What are the difference types of stages?
What is job control?
What is staging variable?
Explain datastage architecture?
