Skip navigation links

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

java.lang.Object
oracle.odi.interfaces.interactive.support.actions.InterfaceActionAddLookup

All Implemented Interfaces:

IInterfaceAction

public class InterfaceActionAddLookup

extends java.lang.Object

implements IInterfaceAction

InterfaceActionAddLookup is an interface action class used to create lookup of a data source in an interface data set. Alternately a lookup from another interface result can be specified. The data source or interface that will be the lookup source is specified explicitly. The lookup condition is similar to a join condition. It should it should specify a lookup condition relationship between an existing data source in the interface and the lookup source. For example, if the one interface source has alias "EMP_ALIAS" and the lookup source has an alist "DEPT_ALIAS", then the passed-in SQL lookup string might be "EMP_ALIAS.DEPTNO = DEPT_ALIAS.DEPTNO".

The lookup that is created is owned by the DataSet object that is passed in to the constructor. The existing interface data source specified in the lookup condition must be in the same data set.

If the auto-fix manager is set up for the InteractiveInterfaceHelperWithActions helper, it is possible that the execution location of the lookup may be automatically changed, even if it has been explicitly set in the constructor.

Since:

11.1.1.3.0

See Also:

InteractiveInterfaceHelperWithActions

Nested Class Summary

class

InterfaceActionAddLookup.MyClauseImporter An inner class that implements the <@link IClauseImporter> interface.

Constructor Summary

InterfaceActionAddLookup(DataSet pDataSet, OdiDataStore pOdiDataStore, java.lang.String pAlias, java.lang.String pLookupSql, OdiInterface.ExecutionLocation pExecutionLocation, boolean pSelectLookup)
A constructor to create the lookup creation action, to do a lookup of rows from a data source.

InterfaceActionAddLookup(DataSet pDataSet, OdiInterface pOdiInterface, java.lang.String pAlias, java.lang.String pLookupSql, OdiInterface.ExecutionLocation pExecutionLocation, boolean pSelectLookup)
A constructor to create the lookup creation action, to do a lookup of rows from another interface result.

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

InterfaceActionAddLookup

public InterfaceActionAddLookup(DataSet pDataSet,
                                OdiDataStore pOdiDataStore,
                                java.lang.String pAlias,
                                java.lang.String pLookupSql,
                                OdiInterface.ExecutionLocation pExecutionLocation,
                                boolean pSelectLookup)

A constructor to create the lookup creation action, to do a lookup of rows from a data source.

Parameters:

pDataSet - The data set that contains the lookup driver data source and will contain the lookup object.

pOdiDataStore - The OdiDataStore object to be looked up.

pAlias - The alias to be used for the lookup table.

pLookupSql - The SQL lookup condition string.

pExecutionLocation - The location where the lookup will be executed.

pSelectLookup - If true, creates a select lookup which translates to a data source and an ordinary join. Otherwise an outer join is used.

InterfaceActionAddLookup

public InterfaceActionAddLookup(DataSet pDataSet,
                                OdiInterface pOdiInterface,
                                java.lang.String pAlias,
                                java.lang.String pLookupSql,
                                OdiInterface.ExecutionLocation pExecutionLocation,
                                boolean pSelectLookup)

A constructor to create the lookup creation action, to do a lookup of rows from another interface result.

Parameters:

pDataSet - The data set that contains the lookup driver data source and will contain the lookup object.

pOdiInterface - The other interface whose result will act as the lookup source.

pAlias - The alias to be used for the lookup table.

pLookupSql - The SQL lookup condition string. The string specifies the lookup

pExecutionLocation - The location where the lookup will be executed.

pSelectLookup - If true, creates a select lookup which translates to a data source and an ordinary join. Otherwise an outer join is used.

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