StoredProcTransformation (Java Mapping API framework)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

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

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

All Implemented Interfaces:: Transform

public class StoredProcTransformation
extends Transformation
extends Transformation

The class StoredProcTransformation extents Transformation.

This class implements the logic for Stored Procedure Transformation. The stored procedure must exist in the database before creating a Stored Procedure transformation, and the stored procedure can exist in a source, target, or any database with a valid connection to the PowerCenter Server. If a stored procedure exists then it can be used by the by this transformation instead of creating some other transformation to achieve the same logic.

For Further details see Transformation Guide.

The code snippet for the StoredProcTransformation is

          //create a Stored Procedure Transformation using the constructor given below: 
          Mapping mapping = ...; // mapping to which the transform should be added
          InputSet inputSetObj = ...; // the InputSet object
          Vector vTransformFields = ...; // collection of TransformField objects
          TransformationProperties props = ...; // properties 
          StoredProcTransformation stProcTrans = new StoredProcTransformation( "StProcTrans", "StProcTrans", 
                                                  "This is Stored procedure Transformation", "StProcTrans", 
                                                  mapping, inputSetObj, vTransformFields, props);
          
          //apply the transformation
          OutputSet outputSet = stProcTrans.apply();
          
          //get the first rowset as Stored Procedure always returns a RowSet
          RowSet outRowSet = (RowSet)outputSet.getRowSets().get(0);

Field Summary

Fields inherited from class com.informatica.powercenter.sdk.mapfwk.core.Transformation
`m_templateID, m_templateName, m_transformFieldAttr, sessionTransformInst`

Fields inherited from class com.informatica.powercenter.sdk.mapfwk.core.Table
`m_bReusable, m_readOnly`

Constructor Summary
`StoredProcTransformation()` Default constructor
`StoredProcTransformation(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
`StoredProcTransformation(java.lang.String name, java.lang.String busName, java.lang.String desc, java.lang.String instName, Mapping mapping, InputSet inputSet, java.util.Vector vTransformFields, TransformationProperties properties)` Constructor for Stored Procedure Transformation

Method Summary
`OutputSet`	`apply()` Apply the Stored Procedure Tranformation

Methods inherited from class com.informatica.powercenter.sdk.mapfwk.core.Transformation
add, addInitProp, defaultDuplicateNameRemovalSchema, genOutputSet, getGroupSet, getInitProps, getMapping, getOutFields, getOutputSet, getProperties, getSessionTransformInstanceKeySet, getSessionTransformInstanceProperty, getTemplateID, getTemplateName, getTransContext, getTransformationFieldAttr, getTransformationType, getTransformGroup, setGroupSet, setGroupSet, setMapping, setOutFields, setOutputSet, setReusable, setSessionTransformInstanceProperty, setTemplateIDAndName, setTransContext, setTransformationFieldAttr, setTransformationType, setTransformGroup, standardizeString

Methods inherited from class com.informatica.powercenter.sdk.mapfwk.core.Transformation

add, addInitProp, defaultDuplicateNameRemovalSchema, genOutputSet, getGroupSet, getInitProps, getMapping, getOutFields, getOutputSet, getProperties, getSessionTransformInstanceKeySet, getSessionTransformInstanceProperty, getTemplateID, getTemplateName, getTransContext, getTransformationFieldAttr, getTransformationType, getTransformGroup, setGroupSet, setGroupSet, setMapping, setOutFields, setOutputSet, setReusable, setSessionTransformInstanceProperty, setTemplateIDAndName, setTransContext, setTransformationFieldAttr, setTransformationType, setTransformGroup, standardizeString

Methods inherited from class com.informatica.powercenter.sdk.mapfwk.core.Table
`addField, addMetaExtension, getBusinessName, getDescription, getField, getFields, getInstanceName, getMetaExtensions, getName, getReferencedField, isReadOnly, isReusable, removeField, removeMetaExtension, setBusinessName, setDescription, setFields, setInstanceName, setMetaExtensions, setMetaExtensionValue, setName, setReadOnly`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail