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
Can you define merge?
Name the different types of Lookups in Datastage?
What are sequencers?
What are the types of containers and how to create them?
What is difference between join, merge and lookup stage?
What is quality stage?
How many types of views are there in a datastage director?
Where do the datastage jobs get stored?
What are the types of views in datastage director?
Can you explain engine tier in information server?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Can you filter data in hashed file?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
project Steps,hits, Project level HArd things,Solved methods?