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 to read the length of word in unix?
Explain the importance of surrogate key in data warehousing?
Explain how a source file is populated?
What is data partitioning?
Have you have ever worked in unix environment and why it is useful in datastage?
How many types of stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
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?
What are the types of containers?
What is a folder? Difference types of stages?
How one source columns or rows to be loaded in to two different tables?
What are the various kinds of containers available in datastage?
What is the difference between in process and inter process?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Highlight the main features of datastage?