Which partition is best in performance level?

Questions by yasodha krishnasamy

Showing Answers 1 - 12 of 12 Answers

vijay

  • Sep 3rd, 2012
 

Hash

  Was this answer useful?  Yes

Subhra

  • Sep 27th, 2012
 

Partition by Round Robin

  Was this answer useful?  Yes

Muralidhar

  • May 30th, 2013
 

Same partition.
The reason is it keeps the previous partition and send to output as it is.

It depends on the job design and requrement.

When you specify SAME partitioning, datastage uses the partioing method defined in the previous stage and will not perform any partitioning in the current stage. So, in this case this is the fastest partitioning method.

When you are not bothered about how your data is going to used in the stages down, you can use ROUND ROBIN. As per this this method, input records are distributed among nodes one at a time in a round fashion.

If you are going to perform lookups and sorts on some column/s in the later stages of the design, then identify them in the begining stages and do a HASH partition. Later you can use SAME partition.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions