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
- 10762 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
How do you schedule or monitoring the job?
What are the stages in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is process model?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are system variables and sequencers in datastage
What all the types of jobs you developed?
What is the flow of loading data into fact & dimensional tables?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the command line function to import and export the ds jobs?
AGGREGATOR default datatype
How a server job can be converted to a parallel job?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Explain the situation where you have applied SCD in your project?
