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
How many types of hash files are there?
What is apt_config in datastage?
Could anyone give brief explanation bout datastage admin
Explain usage analysis in datastage?
What is oci?
What is difference between join, merge and lookup stage?
Demonstrate experience in maintaining quality process standards?
What are stage variables, derivations and constants?
What is the method of removing duplicates, without the remove duplicate stage?
What is the roundrobin collector?
What is the difference between informatica and datastage?
Can you define merge?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How we can covert server job to a parallel job?
What are the primary usages of datastage tool?