which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?

Answers were Sorted based on User's Feedback



which is more expensive hash or modulus partitioning? when do you use modulus partitioning?..

Answer / ankit gosain

Hi All,

Hash partitioning is more expensive than modulus but it'll
give better performance as well.
The basic difference is, you can apply Modulus partitioning
for the number fields only while you can apply Hash
partitioning for Varchar and any type of field.

If you have more queries, you can mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Is This Answer Correct ?    4 Yes 0 No

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?..

Answer / nish

has partitioning when distinct key fields are less.

Modulus when the key field are very few and numeric.

Modulus = x%y so the field ought to be numeric

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is the difference between passive stage and active stage?

0 Answers  


WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,


Define orabulk and bcp stages?

0 Answers  


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  






input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,


if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  


What is the different type of jobs in datastage?

0 Answers  


Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  


What's the Main Function of the Staging area in DWH

3 Answers   Oracle,


How did you reconcile source with target?

3 Answers   HP,


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,


Categories