which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
- 2 Answers
- 7109 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
How do you run datastage job from the command line?
Define ds designer?
What is a quality stage in datastage tool?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between Datastage 7.5 and 7.0?
Which warehouse using in your datawarehouse
Describe stream connector?
How we can covert server job to a parallel job?
Define repository tables in datastage?
What is the purpose of pivot stage?
Define oconv () and iconv () functions in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
