|
Oracle® Data Integrator Java API Reference 11g Release 1 (11.1.1.5.0) E17060-02 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.odi.interfaces.interactive.support.actions.InterfaceActionOnLookupSetSelectLookup
public class InterfaceActionOnLookupSetSelectLookup
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").
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 |
---|
public InterfaceActionOnLookupSetSelectLookup(SourceDataStore pSourceDataStore, boolean pSelectLookup)
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 |
---|
public void performAction(IInterfaceActionListener pInterfaceActionListener, IInterfaceUndoListener pInterfaceUndoListener, IActionHelper pActionHelper)
IInterfaceAction
performAction
in interface IInterfaceAction
pInterfaceActionListener
- the interface action listener instancepInterfaceUndoListener
- the interface undo listener instancepActionHelper
- the action helper instance
|
Oracle® Data Integrator Java API Reference 11g Release 1 (11.1.1.5.0) E17060-02 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |