Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What is combinability and non combinability?

asked mar September 20, 2014 06:32 AM  

What is combinability and non combinability?


1 Answers

answered By vishnoiprem   0  
Combinabilty mode means datastage will combine the operators in a single process.If  combinability mode is disabled,the number of Unix processes will increase.  It can be set by setting "APT_DISABLE_COMBINATION".(Env variable) Combined operators generally improve performance at least slightly (in some cases the difference is dramatic). There may also be situations where combining operators actually hurts performance, however. Identifying such operators can be difficult without trial and error. The most common situation arises when multiple operators are performing disk I/O (for example, the various file stages and sort). In these sorts of situations, turning off combination for those specific stages may result in a performance increase if the flow is I/O bound. Combinable operators often provide a dramatic performance increase when a large number of variable length fields are used in a flow.
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

datastage × 4

Asked 1 year and 1 month ago ago
Number of Views -522
Number of Answers -1
Last updated
2 years and 1 month ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!