Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on What is driving port? within the Data Warehousing forums, part of the Databases category; In Abinitio, What is driving port? NOTE : [This question was asked by a visitor]...
|
|||||||
|
|||
|
Re: What is driving port?
hi jobhelper
When you set the sorted-input parameter of “JOIN” component to “In memory: Input need not be sorted”, you can find the driving port. Generally driving port use to improve performance in a graph. The driving input is the largest input. All other inputs are read into memory. For example, suppose the largest input to be joined is on the in1 port. Specify a port number of 1 as the value of the driving parameter. The component reads all other inputs to the join — for example, in0, and in2 — into memory. Default is 0, which specifies that the driving input is on port in0. Join also improves performance by loading all records from all inputs except the driving input into main memory. bye
__________________
:) NEVER SAY DIE. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Output port and Group by clause in SQ | JobHelper | Data Warehousing | 1 | 01-04-2007 12:17 PM |