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
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Can you implement SCD2 using join, transformer and funnel stage?
explain about citrix scheduling tool in datastage
How rejected rows are managed in datastage?
Terminate Activity
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the types of containers and how to create them?
Give an idea of system variables.
What is the difference between passive stage and active stage?
What are system variables and sequencers in datastage
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Describe routines in datastage? Enlist various types of routines.
Can you explain players in datastage?
How many types of views are there in a datastage director?