what is the differeces between hash and modulus partition methods

what is the differeces between hash and modulus partition
methods

Question Posted / guest

4 Answers
28842 Views
TCS, I also Faced
E-Mail Answers

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

Define project in datastage?

0 Answers

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers CTS,

How did you reconcile source with target?

3 Answers HP,

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers CTS, HCL, IBM, Wipro,

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers

How can we do null handling in sequential files?

3 Answers Reliance,

I have a few records just I want to store each records tow times in target how?

2 Answers Polaris,

how to unlock a locked job in datastage 8.0

3 Answers HCL,

What is staging variable?

0 Answers

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers Virtusa,

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers IBM,

For more Data Stage Interview Questions Click Here