com.informatica.powercenter.sdk.mapfwk.core
Class JoinerTransformation

java.lang.Object
  com.informatica.powercenter.sdk.mapfwk.core.Table
      com.informatica.powercenter.sdk.mapfwk.core.Transformation
          com.informatica.powercenter.sdk.mapfwk.core.JoinerTransformation

All Implemented Interfaces:

Transform

public class JoinerTransformation
extends Transformation

This class provides by the Joiner Transformation functionality. It extends the base Transformation class

You can use the Joiner transformation to join source data from two related heterogeneous sources residing in different locations or file systems. Or, you can join data from the same source.

The Joiner transformation joins two sources with at least one matching port. The Joiner transformation uses a condition that matches one or more pairs of ports between the two sources. If you need to join more than two sources, you can add more Joiner transformations to the mapping.

The Joiner transformation requires input from two separate pipelines or two branches from one pipeline.

The snippet code shows how to create Joiner Transformation,

            //create a Joiner Transformation using the constructor given below: 
          Mapping mapping = ...; // mapping to which the transform should be added
          Vector vDetailInputSets = ...; // collection of InputSet objects
          InputSet masterInputSet = ...; // The inputSet which is the master in the joiner transformation 
          String joinCnd = ...; // Join condition
          TransformationProperties props = ...; // properties           
          JoinerTransformation joinTrans = new JoinerTransformation( "JoinerTrans", "JoinerTrans", 
                                                  "This is joiner transformation", "JoinerTrans", 
                                                  mapping, vDetailInputSets, masterinputSet, joinCnd, props );
          
          //apply the transformation
          OutputSet outputSet = joinerTrans.apply();
          
          //get the first rowset as Joiner always returns a RowSet
          RowSet outRowSet = (RowSet)outputSet.getRowSets().get(0);     
 

JoinerTransformation

public JoinerTransformation()

Default constructor

JoinerTransformation

public JoinerTransformation(java.lang.String name,
                            java.lang.String busName,
                            java.lang.String desc,
                            java.lang.String instName)

Initialize the object with name, business name, description and instance name

Parameters:

name - name of the table

busName - business name

desc - description

instName - instance name

JoinerTransformation

public JoinerTransformation(java.lang.String name,
                            java.lang.String busName,
                            java.lang.String desc,
                            java.lang.String instName,
                            Mapping mapping,
                            java.util.Vector vDetailInputSets,
                            InputSet masterInputSet,
                            java.lang.String joinCnd,
                            TransformationProperties props)
                     throws InvalidTransformationException

Throws:

InvalidTransformationException

apply

public OutputSet apply()
                throws InvalidTransformationException

Apply the Transformation.

Returns:

OutputSet object

Throws:

InvalidTransformationException - exception

genOutputSet

protected OutputSet genOutputSet(java.util.Vector inputSet)

Generate OutputSet for a given collection of InputSet objects

Overrides:

genOutputSet in class Transformation

Parameters:

inputSet - collection of InputSets

Returns:

OutputSet object