what is the differeces between hash and modulus partition
methods

Answers were Sorted based on User's Feedback



what is the differeces between hash and modulus partition methods..

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

what is the differeces between hash and modulus partition methods..

Answer / vijay

Hi this is Vijay

Modulus Hash

1. For numerics 1. For Numerics and characters
2. Datatype specific 2. Not Datatype spefic

Is This Answer Correct ?    13 Yes 1 No

what is the differeces between hash and modulus partition methods..

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

what is the differeces between hash and modulus partition methods..

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

Post New Answer

More Data Stage Interview Questions

EXPLAIN SCD

0 Answers   CTS,


How many areas for files does datastage have?

0 Answers  


there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,


How a source file is populated?

0 Answers  


in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,






in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,


Terminate Activity

0 Answers   CTS,


i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  


what is sparse lookup?

7 Answers   IBM,


How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  


I have 100 records how can I load at a time from the single time

1 Answers  


What is a quality stage?

1 Answers  


Categories