which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of containers in datastage?
How rejected rows are managed in datastage?
How many types of views are there in a datastage director?
What is the difference between passive stage and active stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what are the errors,warnings in datastage
Describe stream connector?
What is the purpose of interprocessor stage in server jobs?
What are the primary usages of datastage tool?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the features of datastage flow designer?
What is a folder? Difference types of stages?
How many areas for files does datastage have?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between orabulk and bcp stages?