what is the differeces between hash and modulus partition
methods

Answer Posted / kiran

hai this is Kiran..,

If the key field is numeric use modules else hash
partition.as per performance tuning.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

client know skid info?

1860


If you want to use a same piece of code in different jobs, how will you achieve this?

1045


Is possible to create skid in dim,fact tables?

2388


Different ways a project can be moved to production ?...example ….export-import and Version control.

2195


what are the errors,warnings in datastage

2399


How to reverse the string using unix?

3154


How do y read Sequential file from job control?

15084


how to sort two columns in single job in datastage.

2721


What are sequencers?

840


What is the sortmerge collector?

905


Can you explain how could anyone drop the index before loading the data in target in datastage?

1228


Demonstrate experience in maintaining quality process standards?

2185


How we can covert server job to a parallel job?

789


What is the flow of loading data into fact & dimensional tables?

827


What are the different plug-ins stages used in your projects?

845