which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
- 2 Answers
- 6544 Views
- TIAA CREF, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
how can or from where we can get reference data in scd type2 implementation?
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
What are the different plug-ins stages used in your projects?
How can we run same job in 1 day 2 times
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
Difference between in process and inter process?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
What are iconv and oconv?
what is combinability and non combinability?
Hi Vijay here For Four CPU's how many nodes will required?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Teradata 
