what is the differeces between hash and modulus partition
methods
- 4 Answers
- 29407 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
hai this is Kiran..,
If the key field is numeric use modules else hash
partition.as per performance tuning.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / venkata
Modulus is nothing but Modulus in Maths, so it can be
performed only on Numeric Data Fields, Hash can be used for
any kind of data fileds, it will assign similar values in
the partioning
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / maruthi
HASH-KEY:- HERE DATA WILL BE POPULATED INSUCH A WAY THAT
REALATED DATA WILL STAY TOGETHER.
RANGE OF PRIMERY KER RECORDS WILL BE POPULATED TO ONE
PARTITION.
EG.)ALL PRIMARY RECORDS IN THIS MONTH WILL BE POPULATED TO
ON E PARTIOTION.
MODULUS:-PARTITIONED DATA WILL PROVIDE SOME INFORMATION.
IN THE SENSE CUSTOMERS RELATED TO ONE STORE WILL POPULATED
TO ONE PARTIOTION.
| Is This Answer Correct ? | 2 Yes | 10 No |
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
how to load meta data
why do u need the IOS upgradation in a FC switch
Is it possible to query a hash file?
What are the repository tables in datastage?
whats relation between configuration file and datasets?
What are the differences between datastage and informatica?
How to create user defined environment varibale(parameter)?
How a server job can be converted to a parallel job?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Teradata 
