Skip navigation links

Oracle® Data Integrator Java API Reference
11g Release 1 (11.1.1.7.0)

E17060-04


oracle.odi.interfaces.interactive.support.actions
Class InterfaceActionOnLookupSetSelectLookup

java.lang.Object
  extended by oracle.odi.interfaces.interactive.support.actions.InterfaceActionOnLookupSetSelectLookup

All Implemented Interfaces:
IInterfaceAction

public class InterfaceActionOnLookupSetSelectLookup
extends java.lang.Object
implements IInterfaceAction

InterfaceActionOnLookupSetSelectLookup is an interface action class used to set the lookup select type for a lookup object. The select type determines whether a left outer join in the from clause is used for the lookup, or if the lookup is done in the select list, as a scalar SQL query. If the "selectLookup" flag is true, then a scalar SQL query in the select list is used, and no left outer join is added to the FROM clause.

For example, if the interface has a source EMP with a lookup on DEPT, and "selectLookup" is set to true, the generated code would look something like this:

select SRC_EMP.DEPT_ID C1_DEPT_ID,
(Select SRC_DEPARTMENT.DEPT_NAME From ODI_SRC.SRC_DEPARTMENT SRC_DEPARTMENT where SRC_EMP.DEPT_ID=SRC_DEPARTMENT.DEPT_ID) C4_DEPT_NAME,
from ODI_SRC.SRC_EMP SRC_EMP


If "selectLookup is set to false, then the code would look something like this:

select SRC_EMP.DEPT_ID C1_DEPT_ID,
SRC_DEPARTMENT.DEPT_NAME C4_DEPT_NAME,
from ODI_SRC.SRC_EMP SRC_EMP, ODI_SRC.SRC_DEPARTMENT SRC_DEPARTMENT


In this case a left outer join is not used because the technology ("ORACLE") does not support ordered joins (The "Reference" setting in the "Data Handling" node of the technology editor is set to "NOT ORDERED").

Since:
11.1.1.3.0
See Also:
InteractiveInterfaceHelperWithActions

Constructor Summary
InterfaceActionOnLookupSetSelectLookup(SourceDataStore pSourceDataStore, boolean pSelectLookup)
          The constructor for the action class.

 

Method Summary
 void performAction(IInterfaceActionListener pInterfaceActionListener, IInterfaceUndoListener pInterfaceUndoListener, IActionHelper pActionHelper)
          Action that is performed on the ODI interface objects.

 

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Constructor Detail

InterfaceActionOnLookupSetSelectLookup

public InterfaceActionOnLookupSetSelectLookup(SourceDataStore pSourceDataStore,
                                              boolean pSelectLookup)
The constructor for the action class.
Parameters:
pSourceDataStore - The lookup data store for which to change the lookup setting.
pSelectLookup - The "selectLookup" setting (see class javadoc for this class for more explanation of the setting).

Method Detail

performAction

public void performAction(IInterfaceActionListener pInterfaceActionListener,
                          IInterfaceUndoListener pInterfaceUndoListener,
                          IActionHelper pActionHelper)
Description copied from interface: IInterfaceAction
Action that is performed on the ODI interface objects.
Specified by:
performAction in interface IInterfaceAction
Parameters:
pInterfaceActionListener - the interface action listener instance
pInterfaceUndoListener - the interface undo listener instance
pActionHelper - the action helper instance

Skip navigation links

Oracle® Data Integrator Java API Reference
11g Release 1 (11.1.1.7.0)

E17060-04


Copyright © 2010, 2013, Oracle and/or its affiliates. All rights reserved.