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 / shar
Well The basic idea is:
Same key column values are given to the same node.
Hence
1.(e_id)
node1 node2 node1 node2 node3
1,10 2,10 1,10 2,10 3,20
3,20 4,20 4,20 5,30 6,40
5,30 6,40
2. (dept_no)
node1 node2 node1 node2 node3
1,10 3,20 1,10 3,20 5,30
2,10 4,20 2,10 4,20 6,40
5,30 6,40
(This is where pranay went wrong 6,40 will go to node3
instead of node1.)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to export or import the jobs in .ISX file
Define Job control?
How do you remove duplicate values in datastage?
What are stage variables and constants?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
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 ?
How can you write parallel routines in datastage PX?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How you can fix the truncated data error in datastage?
How to reverse the string using unix?
Terminate Activity
why do u need the IOS upgradation in a FC switch
What are the components of datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?