Preface
Working with Transformations
- Transformations Overview
- Creating a Transformation
- Configuring Transformations
  - Renaming Transformations
- Transformation Ports
- Multi-Group Transformations
- Working with Expressions
- Local Variables
- Default Values for Ports
- Configuring Tracing Level in Transformations
- Reusable Transformations
Aggregator Transformation
- Aggregator Transformation Overview
- Components of the Aggregator Transformation
  - Configuring Aggregator Transformation Properties
  - Configuring Aggregator Transformation Ports
- Configuring Aggregate Caches
- Aggregate Expressions
- Group By Ports
  - Non-Aggregate Expressions
  - Default Values
- Using Sorted Input
  - Sorted Input Conditions
  - Sorting Data
- Creating an Aggregator Transformation
- Tips for Aggregator Transformations
- Troubleshooting Aggregator Transformations
Custom Transformation
- Custom Transformation Overview
- Creating Custom Transformations
  - Rules and Guidelines for Custom Transformations
  - Custom Transformation Components
- Working with Groups and Ports
- Working with Port Attributes
  - Editing Port Attribute Values
- Custom Transformation Properties
  - Setting the Update Strategy
  - Working with Thread-Specific Procedure Code
- Working with Transaction Control
- Blocking Input Data
- Working with Procedure Properties
- Creating Custom Transformation Procedures
Custom Transformation Functions
- Custom Transformation Functions Overview
  - Working with Handles
- Function Reference
- Working with Rows
  - Rules and Guidelines for Row-Based and Array-Based Data Access Mode
- Generated Functions
- API Functions
- Array-Based API Functions
Data Masking Transformation
- Data Masking transformation
- Masking Properties
  - Locale
  - Masking Types
  - Repeatable Output
  - Seed
  - Mapping Parameters
  - Associated O/P
- Key Masking
  - Masking String Values
  - Masking Numeric Values
  - Masking Datetime Values
- Substitution Masking
  - Dictionaries
  - Storage Tables
    - Encrypting Storage Tables for Substitution Masking
  - Substitution Masking Properties
  - Relational Dictionary
  - Connection Requirements
  - Rules and Guidelines for Substitution Masking
- Dependent Masking
  - Dependent Masking Example
  - Repeatable Dependent Masking
- Random Masking
  - Masking Numeric Values
  - Masking String Values
  - Masking Date Values
- Applying Masking Rules
  - Mask Format
  - Source String Characters
    - Source String Example
  - Result String Replacement Characters
    - Result String Replacement Characters Example
  - Range
  - Blurring
    - Blurring Numeric Values
    - Blurring Date Values
- Expression Masking
  - Repeatable Expression Masking
  - Rules and Guidelines for Expression Masking
- Format Preserving Encryption
- Special Mask Formats
- Social Security Number Masking
  - Social Security Number Format
  - Area Code Requirement
  - Repeatable Social Security Number Masking
- Credit Card Number Masking
- Phone Number Masking
- Email Address Masking
  - Advanced Email Masking
    - Configuration Parameters for an Advanced Email Address Masking Type
    - Expressions for the Advanced Email Address Masking Type
- Social Insurance Number Masking
  - SIN Start Digit
  - Repeatable SIN Numbers
- IP Address Masking
- URL Address Masking
- Default Value File
- Data Masking Transformation Session Properties
- Rules and Guidelines for Data Masking Transformations
Data Masking Examples
- Name and Address Lookup Files
- Substituting Data with the Lookup Transformation
- Masking Data with an Expression Transformation
Expression Transformation
- Expression Transformation Overview
- Expression Transformation Components
- Configuring Ports
  - Calculating Values
- Creating an Expression Transformation
External Procedure Transformation
- External Procedure Transformation Overview
- Configuring External Procedure Transformation Properties
- Developing COM Procedures
- Developing Informatica External Procedures
- Distributing External Procedures
  - Distributing COM Procedures
    - Distributing a COM Visual Basic Procedure
    - Distributing a COM Visual Basic Procedure Manually
  - Distributing Informatica Modules
- Development Notes
- Service Process Variables in Initialization Properties
- External Procedure Interfaces
Filter Transformation
- Filter Transformation Overview
- Filter Transformation Components
  - Configuring Filter Transformation Ports
- Filter Condition
  - Filtering Rows with Null Values
- Steps to Create a Filter Transformation
- Tips for Filter Transformations
HTTP Transformation
- HTTP Transformation Overview
  - Authentication
  - Connecting to the HTTP Server
- Creating an HTTP Transformation
- Configuring the Properties Tab
- Configuring the HTTP Tab
- Examples
Identity Resolution Transformation
- Identity Resolution Transformation Overview
- Create and Configure the Transformation
- Identity Resolution Transformation Tabs
- Groups and Ports
  - Input Groups and Ports
  - Output Groups and Ports
Java Transformation
- Java Transformation Overview
- Using the Java Code Tab
- Configuring Ports
  - Creating Groups and Ports
  - Setting Default Port Values
    - Input and Output Ports
    - Input/Output Ports
- Configuring Java Transformation Properties
  - Working with Transaction Control
    - Transformation Scope
    - Generate Transaction
  - Setting the Update Strategy
- Developing Java Code
- Configuring Java Transformation Settings
- Compiling a Java Transformation
- Fixing Compilation Errors
  - Locating the Source of Compilation Errors
    - Locating Errors in the Code Entry Tabs
    - Locating Errors in the Full Code Window
  - Identifying the Source of Compilation Errors
    - User Code Errors
    - Non-User Code Errors
Java Transformation API Reference
- Java Transformation API Methods Overview
- commit
- failSession
- generateRow
- getInRowType
- getMetadata
- incrementErrorCount
- isNull
- logError
- logInfo
- rollBack
- setNull
- setOutRowType
- storeMetadata
Java Expressions
- Java Expressions Overview
  - Expression Function Types
- Using the Define Expression Dialog Box to Define an Expression
- Working with the Simple Interface
  - invokeJExpression
  - Simple Interface Example
- Working with the Advanced Interface
- JExpression Class API Reference
Java Transformation Example
- Java Transformation Example Overview
- Step 1. Import the Mapping
- Step 2. Create Transformation and Configure Ports
- Step 3. Enter Java Code
- Import Packages Tab
- Helper Code Tab
- On Input Row Tab
- Step 4. Compile the Java Code
- Step 5. Create a Session and Workflow
  - Sample Data
Joiner Transformation
- Joiner Transformation Overview
  - Working with the Joiner Transformation
- Joiner Transformation Properties
- Defining a Join Condition
- Defining the Join Type
- Using Sorted Input
- Joining Data from a Single Source
- Blocking the Source Pipelines
  - Unsorted Joiner Transformation
  - Sorted Joiner Transformation
    - Caching Master Rows
- Working with Transactions
- Creating a Joiner Transformation
- Tips for Joiner Transformations
Lookup Transformation
- Lookup Transformation Overview
- Lookup Source Types
- Connected and Unconnected Lookups
  - Connected Lookups
  - Unconnected Lookups
- Lookup Components
- Lookup Properties
  - Configuring Lookup Properties in a Session
- Lookup Query
- Lookup Condition
- Lookup Caches
- Return Multiple Rows
  - Rules and Guidelines for Returning Multiple Rows
- Configuring Unconnected Lookup Transformations
- Database Deadlock Resilience
- Creating a Lookup Transformation
  - Creating a Reusable Pipeline Lookup Transformation
  - Creating a Non-Reusable Pipeline Lookup Transformation
- Tips for Lookup Transformations
Lookup Caches
- Lookup Caches Overview
  - Cache Comparison
- Building Connected Lookup Caches
  - Sequential Caches
  - Concurrent Caches
- Using a Persistent Lookup Cache
- Working with an Uncached Lookup or Static Cache
- Sharing the Lookup Cache
  - Sharing an Unnamed Lookup Cache
    - Guidelines for Sharing an Unnamed Lookup Cache
  - Sharing a Named Lookup Cache
    - Guidelines for Sharing a Named Lookup Cache
- Tips for Lookup Caches
Dynamic Lookup Cache
- Dynamic Lookup Cache Overview
- Dynamic Lookup Properties
- Lookup Transformation Values
- Dynamic Lookup Cache Updates
  - Insert Else Update
  - Update Else Insert
- Mappings with Dynamic Lookups
- Conditional Dynamic Cache Updates
  - Session Processing
  - Configuring a Conditional Dynamic Cache Lookup
- Dynamic Cache Update with Expression Results
- Synchronizing Cache with the Lookup Source
  - NewLookupRow
  - Configuring Dynamic Cache Synchronization
- Dynamic Lookup Cache Example
- Rules and Guidelines for Dynamic Lookup Caches
Normalizer Transformation
- Normalizer Transformation Overview
- Normalizer Transformation Components
- Normalizer Transformation Generated Keys
  - Storing Generated Key Values
  - Changing the Generated Key Values
- VSAM Normalizer Transformation
- Pipeline Normalizer Transformation
- Using a Normalizer Transformation in a Mapping
  - Generating Key Values
- Troubleshooting Normalizer Transformations
Rank Transformation
- Rank Transformation Overview
- Ports in a Rank Transformation
  - Rank Index
- Defining Groups
- Creating a Rank Transformation
Router Transformation
- Router Transformation Overview
- Working with Groups
- Working with Ports
- Connecting Router Transformations in a Mapping
- Creating a Router Transformation
Sequence Generator Transformation
- Sequence Generator Transformation Overview
- Sequence Generator Ports
  - NEXTVAL Port
    - Create Keys
    - Replace Missing Values
  - CURRVAL
- Sequence Generator Transformation Properties
- Sequence Generator Advanced Properties
  - Reset
- Creating a Sequence Generator Transformation
- Sequence Generator Transformation in a Non-native Environment
  - Sequence Generator Transformation on the Blaze Engine
  - Sequence Generator Transformation on the Spark Engine
Sorter Transformation
- Sorter Transformation Overview
- Sorting Data
- Sorter Transformation Properties
- Creating a Sorter Transformation
Source Qualifier Transformation
- Source Qualifier Transformation Overview
- Source Qualifier Transformation Properties
- Default Query
  - Viewing the Default Query
  - Overriding the Default Query
- Joining Source Data
- Adding an SQL Query
- Entering a User-Defined Join
- Outer Join Support
- Entering a Source Filter
- Using Sorted Ports
- Select Distinct
  - Overriding Select Distinct in the Session
- Adding Pre- and Post-Session SQL Commands
- Creating a Source Qualifier Transformation
  - Creating a Source Qualifier Transformation Manually
  - Configuring Source Qualifier Transformation Options
- Troubleshooting Source Qualifier Transformations
SQL Transformation
- SQL Transformation Overview
- Script Mode
  - Example
  - Rules and Guidelines for Script Mode
- Query Mode
- Connecting to Databases
- Session Processing
- Input Row to Output Row Cardinality
- SQL Transformation Properties
- SQL Statements
- Creating an SQL Transformation
Using the SQL Transformation in a Mapping
- SQL Transformation Example Overview
- Dynamic Update Example
- Dynamic Connection Example
Stored Procedure Transformation
- Stored Procedure Transformation Overview
- Using a Stored Procedure in a Mapping
- Writing a Stored Procedure
  - Sample Stored Procedure
- Creating a Stored Procedure Transformation
- Configuring a Connected Transformation
- Configuring an Unconnected Transformation
  - Calling a Stored Procedure From an Expression
  - Calling a Pre- or Post-Session Stored Procedure
- Error Handling
- Stored Procedure Options
- Expression Rules
- Tips for Stored Procedure Transformations
- Troubleshooting Stored Procedure Transformations
Transaction Control Transformation
- Transaction Control Transformation Overview
- Transaction Control Transformation Properties
  - Properties Tab
  - Example
- Using Transaction Control Transformations in Mappings
  - Sample Transaction Control Mappings with Multiple Targets
- Mapping Guidelines and Validation
- Creating a Transaction Control Transformation
Union Transformation
- Union Transformation Overview
  - Rules and Guidelines for Union Transformations
  - Union Transformation Components
- Working with Groups and Ports
- Creating a Union Transformation
- Using a Union Transformation in a Mapping
Unstructured Data Transformation
- Unstructured Data Transformation Overview
- Configuring the Unstructured Data Option
  - Configuring the Data Transformation Repository Directory
- Data Transformation Service Types
- Unstructured Data Transformation Components
- Unstructured Data Transformation Ports
- Unstructured Data Transformation Service Names
- Relational Hierarchies
  - Exporting the Hierarchy Schema
- Mappings
- Creating an Unstructured Data Transformation
Update Strategy Transformation
- Update Strategy Transformation Overview
  - Setting the Update Strategy
- Flagging Rows Within a Mapping
- Setting the Update Strategy for a Session
  - Specifying an Operation for All Rows
  - Specifying Operations for Individual Target Tables
- Update Strategy Checklist
XML Transformations
- XML Source Qualifier Transformation
- XML Parser Transformation
- XML Generator Transformation

Transformation Guide

10.5.6
- 10.5.7
- 10.5.1
- 10.5
- 10.4.0

Back Next

Port and Property Attribute Property IDs

The following tables list the property IDs for the port and property attributes in the Custom transformation. Each table lists a Custom transformation handle and the property IDs you can access with the handle in a property function.

The following table lists INFA_CT_MODULE _HANDLE property IDs:

Handle Property ID	Datatype	Description
INFA_CT_MODULE_NAME	String	Specifies the module name.
INFA_CT_SESSION_INFA_VERSION	String	Specifies the Informatica version.
INFA_CT_SESSION_CODE_PAGE	Integer	Specifies the Integration Service code page.
INFA_CT_SESSION_DATAMOVEMENT_MODE	Integer	Specifies the data movement mode. The Integration Service returns one of the following values: eASM_MBCS eASM_UNICODE
INFA_CT_SESSION_VALIDATE_CODEPAGE	Boolean	Specifies whether the Integration Service enforces code page validation.
INFA_CT_SESSION_PROD_INSTALL_DIR	String	Specifies the Integration Service installation directory.
INFA_CT_SESSION_HIGH_PRECISION_MODE	Boolean	Specifies whether session is configured for high precision.
INFA_CT_MODULE_RUNTIME_DIR	String	Specifies the runtime directory for the DLL or shared library.
INFA_CT_SESSION_IS_UPD_STR_ALLOWED	Boolean	Specifies whether the Update Strategy Transformation property is selected in the transformation.
INFA_CT_TRANS_OUTPUT_IS_REPEATABLE	Integer	Specifies whether the Custom transformation produces data in the same order in every session run. The Integration Service returns one of the following values: eOUTREPEAT_NEVER = 1 eOUTREPEAT_ALWAYS = 2 eOUTREPEAT_BASED_ON_INPUT_ORDER = 3
INFA_CT_TRANS_FATAL_ERROR	Boolean	Specifies if the Custom Transformation caused a fatal error. The Integration Service returns one of the following values: INFA_TRUE INFA_FALSE

The following table lists INFA_CT_PROC_HANDLE property IDs:

Handle Property ID	Datatype	Description
INFA_CT_PROCEDURE_NAME	String	Specifies the Custom transformation procedure name.

The following table lists INFA_CT_TRANS_HANDLE property IDs:

Handle Property ID	Datatype	Description
INFA_CT_TRANS_INSTANCE_NAME	String	Specifies the Custom transformation instance name.
INFA_CT_TRANS_TRACE_LEVEL	Integer	Specifies the tracing level. The Integration Service returns one of the following values: eTRACE_TERSE eTRACE_NORMAL eTRACE_VERBOSE_INIT eTRACE_VERBOSE_DATA
INFA_CT_TRANS_MAY_BLOCK_DATA	Boolean	Specifies if the Integration Service allows the procedure to block input data in the current session.
INFA_CT_TRANS_MUST_BLOCK_DATA	Boolean	Specifies if the Inputs Must Block Custom transformation property is selected.
INFA_CT_TRANS_ISACTIVE	Boolean	Specifies whether the Custom transformation is an active or passive transformation.
INFA_CT_TRANS_ISPARTITIONABLE	Boolean	Specifies if you can partition sessions that use this Custom transformation.
INFA_CT_TRANS_IS_UPDATE_STRATEGY	Boolean	Specifies if the Custom transformation behaves like an Update Strategy transformation.
INFA_CT_TRANS_DEFAULT_UPDATE_STRATEGY	Integer	Specifies the default update strategy. eDUS_INSERT eDUS_UPDATE eDUS_DELETE eDUS_REJECT eDUS_PASSTHROUGH
INFA_CT_TRANS_NUM_PARTITIONS	Integer	Specifies the number of partitions in the sessions that use this Custom transformation.
INFA_CT_TRANS_DATACODEPAGE	Integer	Specifies the code page in which the Integration Service passes data to the Custom transformation. Use the set data code page function if you want the Custom transformation to access data in a different code page.
INFA_CT_TRANS_TRANSFORM_SCOPE	Integer	Specifies the transformation scope in the Custom transformation. The Integration Service returns one of the following values: eTS_ROW eTS_TRANSACTION eTS_ALLINPUT
INFA_CT_TRANS_GENERATE_TRANSACT	Boolean	Specifies if the Generate Transaction property is enabled. The Integration Service returns one of the following values: INFA_TRUE INFA_FALSE
INFA_CT_TRANS_OUTPUT_IS_REPEATABLE	Integer	Specifies whether the Custom transformation produces data in the same order in every session run. The Integration Service returns one of the following values: eOUTREPEAT_NEVER = 1 eOUTREPEAT_ALWAYS = 2 eOUTREPEAT_BASED_ON_INPUT_ORDER = 3
INFA_CT_TRANS_FATAL_ERROR	Boolean	Specifies if the Custom Transformation caused a fatal error. The Integration Service returns one of the following values: INFA_TRUE INFA_FALSE

The following table lists INFA_CT_INPUT_GROUP_HANDLE and INFA_CT_OUTPUT_GROUP_HANDLE property IDs:

Handle Property ID	Datatype	Description
INFA_CT_GROUP_NAME	String	Specifies the group name.
INFA_CT_GROUP_NUM_PORTS	Integer	Specifies the number of ports in the group.
INFA_CT_GROUP_ISCONNECTED	Boolean	Specifies if all ports in a group are connected to another transformation.
INFA_CT_PORT_NAME	String	Specifies the port name.
INFA_CT_PORT_CDATATYPE	Integer	Specifies the port datatype. The Integration Service returns one of the following values: eINFA_CTYPE_SHORT eINFA_CTYPE_INT32 eINFA_CTYPE_CHAR eINFA_CTYPE_RAW eINFA_CTYPE_UNICHAR eINFA_CTYPE_TIME eINFA_CTYPE_FLOAT eINFA_CTYPE_DOUBLE eINFA_CTYPE_DECIMAL18_FIXED eINFA_CTYPE_DECIMAL28_FIXED eINFA_CTYPE_INFA_CTDATETIME
INFA_CT_PORT_PRECISION	Integer	Specifies the port precision.
INFA_CT_PORT_SCALE	Integer	Specifies the port scale (if applicable).
INFA_CT_PORT_IS_MAPPED	Boolean	Specifies whether the port is linked to other transformations in the mapping.
INFA_CT_PORT_STORAGESIZE	Integer	Specifies the internal storage size of the data for a port. The storage size depends on the datatype of the port.
INFA_CT_PORT_BOUNDDATATYPE	Integer	Specifies the port datatype. Use instead of INFA_CT_PORT_CDATATYPE if you rebind the port and specify a datatype other than the default.

The following table lists INFA_CT_INPUTPORT_HANDLE and INFA_CT_OUTPUT_HANDLE property IDs:

Handle Property ID	Datatype	Description
INFA_CT_PORT_NAME	String	Specifies the port name.
INFA_CT_PORT_CDATATYPE	Integer	Specifies the port datatype. The Integration Service returns one of the following values: eINFA_CTYPE_SHORT eINFA_CTYPE_INT32 eINFA_CTYPE_CHAR eINFA_CTYPE_RAW eINFA_CTYPE_UNICHAR eINFA_CTYPE_TIME eINFA_CTYPE_FLOAT eINFA_CTYPE_DOUBLE eINFA_CTYPE_DECIMAL18_FIXED eINFA_CTYPE_DECIMAL28_FIXED eINFA_CTYPE_INFA_CTDATETIME
INFA_CT_PORT_PRECISION	Integer	Specifies the port precision.
INFA_CT_PORT_SCALE	Integer	Specifies the port scale, if applicable.
INFA_CT_PORT_IS_MAPPED	Boolean	Specifies whether the port is linked to other transformations in the mapping.
INFA_CT_PORT_STORAGESIZE	Integer	Specifies the internal storage size of the data for a port. The storage size depends on the datatype of the port.
INFA_CT_PORT_BOUNDDATATYPE	Integer	Specifies the port datatype. Use instead of INFA_CT_PORT_CDATATYPE if you rebind the port and specify a datatype other than the default.

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Port and Property Attribute Property IDs

Port and Property Attribute Property IDs