Combining connectors in Join, Lookup, and Funnel stages

Balanced Optimization can combine multiple connectors if your job design follows some basic rules.

Balanced Optimization can combine connectors where they are attached to the input links of Join, Lookup, and Funnel stages. It can also combine connectors where one is an input to a Join, Lookup, or Funnel stage, and the other is the output.

Balanced Optimization can combine two connectors that are linked to Join or Lookup stages, or multiple connectors linked to Funnel stages in the root job, if your design obeys the following rules:
  • The Server property (Instance property for DB2 connector) must specify the same literal value, or use the same job parameter to specify the value in all connectors.
  • The Database property must either be blank in all connectors, or specify a database name or job parameter. The connectors can specify different database names or job parameters from each other. (The Database property is not required in the Oracle connector.)
  • The Username property must specify the same literal value, or use the same job parameter to specify the value in both connectors.
  • The Password property must specify the same literal value, or use the same job parameter to specify the value in both connectors.