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 will you move hashed file from one location to another location?
What are the repository tables in datastage?
What are the types of containers and how to create them?
What is the difference between validated and compiled in the datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How you Implemented SCD Type 1 & Type 2 in your project?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
how to add a new records into source?
Terminate Activity
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?
How do y read Sequential file from job control?
Why fact table is in normal form?
Explain connectivity between datastage with datasources?
What could be a data source system?