Skip navigation links

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

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

All Implemented Interfaces:

IInterfaceAction

public class InterfaceActionAddNaturalJoin

extends java.lang.Object

implements IInterfaceAction

InterfaceActionAddNaturalJoin is an interface action class used to create create a natural join between two or more sources in an ODI interface data set. The data sources to be joined are specified explicitly in the constructor. For a natural join, the join condition that is used for the join is automatically determined using the column names in the sources. Each column from the first source that has a corresponding column with an identical name in the second source will used in the join condition in an equals join.

* 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

InterfaceActionAddNaturalJoin(SourceDataStore pSourceDataStore1, SourceDataStore pSourceDataStore2, OdiInterface.ExecutionLocation pExecutionLocation)
Constructor to create an action class instance which will create a natural 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

InterfaceActionAddNaturalJoin

public InterfaceActionAddNaturalJoin(SourceDataStore pSourceDataStore1,
                                     SourceDataStore pSourceDataStore2,
                                     OdiInterface.ExecutionLocation pExecutionLocation)

Constructor to create an action class instance which will create a natural join between two sources in an interface, when performAction is called.

Parameters:

pSourceDataStore1 - A reference to the SourceDataStore object representing the first joined source data store.

pSourceDataStore2 - A reference to the SourceDataStore object representing the second joined source data store.

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