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

java.lang.Object
  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