Interested to Buy Any Domain ? << Click Here >> for more details...
which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
- 2 Answers
- 7764 Views
- TIAA CREF, I also Faced
- E-Mail Answers
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
What are transforms and what is the differenece between routines and transforms?
Explain datastage architecture?
What are the components of ascential data stage?
What are the features of datastage flow designer?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Differentiate between odbc and drs stage?
Demonstrate experience in maintaining quality process standards?
Describe routines in datastage? Enlist various types of routines.
table actions available in oracle connector?
How do you register plug-ins?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
how to abort the job its matain duplicates?
Define oconv () and iconv () functions in datastage?
What are some different alternative commands associated with "dsjob"?
How can one find bugs in job sequence?
