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
- 7870 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
Why do we use exception activity in Datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is data partitioning?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How many areas for files does datastage have?
What is the method of removing duplicates, without the remove duplicate stage?
What could be a data source system?
What are the types of hashed files in data stage
Difference between in process and inter process?
Can we use target hash file as a lookup ?
How to clean the datastage repository?
Which warehouse using in your datawarehouse
Differentiate between datastage and informatica?
What is the difference between datastage and informatica?
Triggers,VIEW,Procedures
