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

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

what is combinability and non combinability?

2 Answers  

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

What are the types of containers in datastage?

0 Answers  

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

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,

What are the partition techniques available in your last project?

1 Answers  

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories