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
- 11007 Views
- FIS, I also Faced
- E-Mail Answers
Answer Posted / pranay
Consider you r having two nodes node 1 and node and u
selected e_id as hash key then
for two nodes for three nodes
node 1 node 2 node 1 node 2 node 3
1,10 2,10 1,10 2,10 3,20
3,20 4,20 4,20 5,30 6,40
5,30 6,40
if u selected dept_no as hash id then
for two node for three node
node 1 node 2 node1 node2 node3
1,10 3,20 1,10 3,20 5,30
2,10 4,20 2,10 4,20
5,30 6,40 6,40
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
Define APT_CONFIG in Datastage?
Differentiate between validated and Compiled in the Datastage?
Which commands are used to import and export the datastage jobs?
What are stage variables?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are orabulk and bcp stages?
Explain the situation where you have applied SCD in your project?
Highlight the main features of datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Describe the main features of datastage?
how to export or import the jobs in .ISX file
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Define meta stage?
describe the Steps to confiure a Qlogic switch
