Skip navigation links

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

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

All Implemented Interfaces:

IInterfaceAction

public class InterfaceActionAddJoin

extends java.lang.Object

implements IInterfaceAction

InterfaceActionAddJoin is an interface action class used to create a join between two or more sources in an ODI interface data set. The source tables are specified in the passed-in SQL string parameter in the constructor. For example, if the two sources have aliases "EMP_ALIAS" and "DEPT_ALIAS", then the passed-in SQL string might be "EMP_ALIAS.DEPTNO = DEPT_ALIAS.DEPTNO".

The join that is created is owned by the DataSet object that is passed in to the constructor. All sources that are joined must be in the same data set. To change the properties of the join, for example to set the relationship between two of the join sources to be an outer join, use the InterfaceActionOnJoinSetJoinProperties class.

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

The same join object should be used to join any number columns between 2 sources, using the "AND" SQL keyword to combine the join condition predicates.

Since:

11.1.1.3.0

See Also:

InteractiveInterfaceHelperWithActions

Constructor Summary

InterfaceActionAddJoin(DataSet pDataSet, java.lang.String pSql, OdiInterface.ExecutionLocation pExecutionLocation)
Constructor to create an action class instance which will create a join between two sources in an interface, when performAction is called.

Method Summary

void	performAction(IInterfaceActionListener pInterfaceActionListener, IInterfaceUndoListener pInterfaceUndoListener, IActionHelper pActionHelper) For internal use only.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

InterfaceActionAddJoin

public InterfaceActionAddJoin(DataSet pDataSet,
                              java.lang.String pSql,
                              OdiInterface.ExecutionLocation pExecutionLocation)

Constructor to create an action class instance which will create a join between two sources in an interface, when performAction is called. This constructor should be called directly to create the action class instance, then the instance should be passed to an InteractiveInterfaceHelperWithActions instance performAction method call in order to perform the create.

Parameters:

pDataSet - A reference to the interface data set that contains both sources.

pSql - The SQL join condition.

pExecutionLocation - The location where the join will be executed.

Method Detail

performAction

public void performAction(IInterfaceActionListener pInterfaceActionListener,
                          IInterfaceUndoListener pInterfaceUndoListener,
                          IActionHelper pActionHelper)

For internal use only.

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