Table of Contents

Search

  1. Preface
  2. Understanding Mapping Architect for Visio
  3. Mapping Templates
  4. Mapping Objects
  5. Mapping Template Rules
  6. Using the Import Mapping Template Wizard
  7. Using the mapgen Command Line Program
  8. Using Informatica Mapping Templates
  9. Glossary

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Custom Transformation

Custom Transformation

You can include a Custom transformation in a mapping template or import a template from a mapping with a Custom transformation.
You can configure the properties and create input and output groups for the Custom transformation. When you include a Custom transformation in a mapping template, you can set it to an active or passive Custom transformation. Set the IsActive property to Yes for an active Custom transformation, and set the property to No for a passive Custom transformation.
The following table describes the required properties and values for an active or passive Custom transformation:
Transformation Property
Description
Transformation Name
Name of the transformation.
Language
Language used for the procedure code.
Runtime Location
Location that contains the DLL or shared library. Default is $PMExtProcDir.
Tracing Level
Amount of detail displayed in the session log for this transformation.
Set the value to Normal for both active and passive Custom transformations.
Is Partitionable
Indicates if you can create multiple partitions in a pipeline that uses this transformation.
Set the value to No for both active and passive Custom transformations.
Inputs Must Block
Indicates if the procedure associated with the transformation must be able to block incoming data.
Set the value to Yes for both active and passive Custom transformations.
IsActive
Indicates if this transformation is an active or passive transformation.
Set the value to Yes for an active Custom transformation, and No for a passive Custom transformation.
Update Strategy Transformation
Indicates if this transformation defines the update strategy for output rows.
Set the value to No for a passive Custom transformation. For an active Custom transformation, you can set the value to Yes or No.
Transformation Scope
Indicates how the Integration Service applies the transformation logic to incoming data.
Set the value to All Input for an active Custom transformation and Row for a passive Custom transformation.
Generate Transaction
Indicates if this transformation can generate transactions. When a Custom transformation generates transactions, it generates transactions for all output groups.
Set the value to No for a passive Custom transformation. For an active Custom transformation, you can set the value to Yes or No.
Output is Repeatable
Indicates if the order of the output data is consistent between session runs.
Set the value to Never for an active Custom transformation and Based on Input Order for a passive Custom transformation.
Requires Single Thread Per Partition
Indicates if the Integration Service processes each partition at the procedure with one thread.
Set the value to Yes for both active and passive Custom transformations.
Output Is Deterministic
Indicates whether the transformation generates consistent output data between session runs.
Set the value to Yes for both active and passive Custom transformations.

0 COMMENTS

We’d like to hear from you!