Abinitio Geek

 Profile Answers by Abinitio Geek 

• Jan 16th, 2007

 

In a join, it is sometimes advantageous to have the Sorted-Input parameter set to "Input need not be sorted". This helps, when we are sure that one of the input ports has far less records than the other port, and the data from that port can be held in memory. In this case, we can set the other port as the driving port.

Say, e.g. Port in0 has 1000 rec and in1 has 1 million records, in this case we set the port in1 as driving port, for which the value would be 1. By default, the driving port value is 0(for in0).

Depending on the requirement, sometimes it more advisable to create a lookup instead. But that depends on the requirement and design.

Hope this helps.

shashi_dhar

• Feb 19th, 2007

 

The largest input is nothing but a driving port

jatin chawla

• Feb 5th, 2013

 

When using in-memory Join we choose one of the input as driving port which is not taken into memory rest all inputs are loaded into memory. Driving port should be the largest input taken. this can be set in the parameter.