which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
Answer Posted / 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 |
Post New Answer View All Answers
How a source file is populated?
What is the purpose of pivot stage and types of containers in datastage
What is the project in datastage?
How do you import and export the datastage jobs?
How can you write parallel routines in datastage PX?
How you can fix the truncated data error in datastage?
How do u convert the columns to rows in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
How many types of stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Define data aggregation?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the differences between datastage and informatica?
What is a merge?
What are the benefits of datastage?