Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

what is the differeces between hash and modulus partition
methods

Question Posted / guest

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

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

Define repository tables in datastage?

0 Answers  

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

which r the connectors used in san?

0 Answers  

How and where you used hash file?

0 Answers  

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

For more Data Stage Interview Questions Click Here
Categories