Preface
Informatica Resources
Informatica Network
Informatica Knowledge Base
Informatica Documentation
Informatica Product Availability Matrixes
Informatica Velocity
Informatica Marketplace
Informatica Global Customer Support
Introduction to Transformations
Introduction to Transformations Overview
Active Transformations
Passive Transformations
Unconnected Transformations
Multi-Strategy Transformations
Transformation Descriptions
Transformations in the Native and Hadoop Environments
Handling Transformation Data Types
Decimal Data Type
Timestamp with Time Zone
Timestamp with Local Time Zone
Developing a Transformation
Multi-Group Transformations
Rules and Guidelines for Multi-Group Transformations
Expressions in Transformations
The Expression Editor
Port Names in an Expression
Adding an Expression to a Port
Comments in an Expression
Expression Validation
Test Expressions
Data Type Conversion
Local Variables
Temporarily Store Data and Simplify Complex Expressions
Store Values Across Rows
Capture Values from Stored Procedures
Guidelines for Configuring Variable Ports
Variable Initialization
Default Values for Ports
User-Defined Default Values
User-Defined Default Input Values
Default Value Validation
User-Defined Default Output Values
General Rules for Default Values
Default Value Validation
Tracing Levels
Reusable Transformations
Reusable Transformation Instances and Inherited Changes
Editing a Reusable Transformation
Editor Views for a Reusable Transformation
Non-Reusable Transformations
Editor Views for a Non-Reusable Transformation
Creating a Transformation
Transformation Ports
Transformation Ports Overview
Create Ports
Configure Ports
Linking Ports
One to One Links
One to Many Links
Manually Linking Ports
Automatically Linking Ports
Rules and Guidelines for Linking Ports
Propagating Port Attributes
Dependency Types
Link Path Dependencies
Implicit Dependencies
Propagated Port Attributes by Transformation
Copying Ports from Excel
Editing Transformations in Excel
Copying Metadata to the Developer Tool
Example: Editing a Transformation in Excel
Rules and Guidelines for Copying from Excel
Transformation Caches
Transformation Caches Overview
Cache Types
Cache Files
Cache File Directory
Cache Size
Auto Cache Size
Specific Cache Size
Cache Size Increase by the Data Integration Service
Cache Size for Partitioned Caches
Cache Size Optimization
Step 1. Set the Tracing Level to Verbose Initialization
Step 2. Run the Mapping in Auto Cache Mode
Step 3. Analyze Caching Performance
Step 4. Configure Specific Cache Sizes
Address Validator Transformation
Address Validator Transformation Overview
Address Reference Data
Types of Address Reference Data
Modes and Templates
Port Groups and Port Selection
Address Validator Transformation Input Port Groups
Address Validator Transformation Output Port Groups
Multiple-Instance Ports
Address Validation Projects
Formatted Addresses and Mail Carrier Standards
Partial Address Completion
Address Validator Status Ports
Element Status Code Definitions
Address Resolution Code Output Port Values
Element Input Status Output Port Values
Element Relevance Output Port Values
Element Result Status Output Port Values
Extended Element Result Status Output Port Values
Mailability Score Output Port Values
Match Code Output Port Values
Geocoding Status Output Port Values
Address Validator Transformation General Settings
Address Validation Properties in the Preferences Window
Address Validation Advanced Properties
Alias Locality
Alias Street
Casing Style
Country of Origin
Country Type
Default Country
Dual Address Priority
Element Abbreviation
Execution Instances
Flexible Range Expansion
Geocode Data Type
Global Max Field Length
Global Preferred Descriptor
Input Format Type
Input Format With Country
Line Separator
Matching Alternatives
Matching Extended Archive
Matching Scope
Max Result Count
Mode
Optimization Level
Output Format Type
Output Format With Country
Preferred Language
Preferred Script
Ranges To Expand
Standardize Invalid Addresses
Tracing Level
Certification Reports
AMAS Report Fields
CASS Report Fields
SendRight Report
SERP Report Fields
Configuring an Address Validator Transformation
Adding Ports to the Address Validator Transformation
Creating User-Defined Templates
Defining Address Validator Models
Defining a Certification Report
Aggregator Transformation
Aggregator Transformation Overview
Aggregator Transformations in Dynamic Mappings
Developing an Aggregator Transformation
Aggregator Transformation Ports
Aggregate Expressions
Aggregate Functions
Nested Aggregate Functions
Conditional Clauses in Aggregate Expressions
Group By Ports
Configure Group By Ports
Group By Parameters
Default Values of Group By Ports
Non-Aggregate Expressions
Aggregator Caches
Sorted Input for an Aggregator Transformation
Sorted Input Conditions
Sorting Data in an Aggregator Transformation
Aggregator Transformation Advanced Properties
Creating a Reusable Aggregator Transformation
Creating a Non-Reusable Aggregator Transformation
Tips for Aggregator Transformations
Troubleshooting Aggregator Transformations
Association Transformation
Association Transformation Overview
Memory Allocation
Association Transformation Advanced Properties
Bad Record Exception Transformation
Bad Record Exception Transformation Overview
Bad Record Exception Output Record Types
Bad Record Exception Management Process Flow
Bad Record Exception Mappings
Bad Record Exception Quality Issues
Human Tasks
Bad Record Exception Ports
Bad Record Exception Transformation Input Ports
Bad Record Exception Transformation Output
Bad Record Exception Configuration View
Generating the Bad Records Table and the Issues Table
Bad Record Exception Issue Assignment
Assigning Ports to Quality Issues
Exception Transformation Advanced Properties
Configuring a Bad Record Exception Transformation
Bad Record Exception Mapping Example
Bad Record Exception Mapplet
Bad Record Exception Example Input Groups
Bad Record Exception Example Configuration
Bad Record Exception Example Mapping Output
Case Converter Transformation
Case Converter Transformation Overview
Case Strategy Properties
Configuring a Case Converter Strategy
Case Converter Transformation Advanced Properties
Classifier Transformation
Classifier Transformation Overview
Classifier Models
Classifier Algorithms
Classifier Transformation Options
Classifier Strategies
Classifier Transformation Advanced Properties
Configuring a Classifier Strategy
Classifier Analysis Example
Create the Classifier Mapping
Input Data Sample
Data Source Configuration
Classifier Transformation Configuration
Router Transformation Configuration
Data Target Configuration
Classifier Mapping Outcome
Comparison Transformation
Comparison Transformation Overview
Field Matching Strategies
Bigram
Hamming Distance
Edit Distance
Jaro Distance
Reverse Hamming Distance
Identity Matching Strategies
Configuring a Comparison Strategy
Comparison Transformation Advanced Properties
Consolidation Transformation
Consolidation Transformation Overview
Consolidation Mappings
Consolidation Transformation Ports
Consolidation Transformation Views
Consolidation Transformation Strategies View
Consolidation Transformation Advanced Properties
Cache File Size
Simple Strategies
Row-Based Strategies
Advanced Strategies
Simple Consolidation Functions
CONSOL_AVG
CONSOL_LONGEST
CONSOL_MAX
CONSOL_MIN
CONSOL_MOSTFREQ
CONSOL_MOSTFREQ_NB
CONSOL_SHORTEST
Row-Based Consolidation Functions
CONSOL_GETROWFIELD
CONSOL_MODALEXACT
CONSOL_MOSTDATA
CONSOL_MOSTFILLED
Consolidation Mapping Example
Input Data
Key Generator Transformation
Consolidation Transformation
Consolidation Mapping Output
Configuring a Consolidation Transformation
Data Masking Transformation
Data Masking Transformation Overview
Masking Techniques
Random Masking
Expression Masking
Key Masking
Substitution Masking
Dependent Masking
Tokenization Masking
Masking Rules
Mask Format
Source String Characters
Result String Replacement Characters
Range
Blurring
Special Mask Formats
Credit Card Number Masking
Email Address Masking
Advanced Email Masking
IP Address Masking
Phone Number Masking
Social Security Number Masking
URL Address Masking
Social Insurance Number Masking
Default Value File
Data Masking Transformation Configuration
Configure the Data Integration Service
Defining the Ports
Configuring Data Masking for Each Port
Previewing the Masked Data
Data Masking Transformation Runtime Properties
Data Masking Example
Read_Customer Data
Customer Data Masking Transformation
Customer Test Data Results
Data Masking Transformation Advanced Properties
Data Processor Transformation
Data Processor Transformation Overview
Data Processor Transformation Views
Data Processor Transformation Ports
Data Processor Transformation Input Ports
Data Processor Transformation Output Ports
Pass-Through Ports
Startup Component
References
Data Processor Transformation Settings
Character Encoding
Rules and Guidelines for Character Encoding
Output Settings
Processing Settings
XMap Settings
XML Output Configuration
Events
Event Types
Data Processor Events View
Logs
Design-Time Event Log
Run-Time Event Log
Viewing an Event Log in the Data Processor Events View
User Log
Data Processor Transformation Development
Create the Data Processor Transformation
Select the Schema Objects
Create Objects in a Blank Data Processor Transformation
Create the Ports
Testing the Transformation
Data Processor Transformation Import and Export
Exporting the Data Processor Transformation as a Service
Importing Multiple Data Transformation Services
Importing a Data Transformation Service
Exporting a Mapping with a Data Processor Transformation to PowerCenter
Decision Transformation
Decision Transformation Overview
Decision Transformation Functions
Decision Transformation Conditional Statements
Decision Transformation Operators
Decision Transformation NULL Handling
Configuring a Decision Strategy
Decision Transformation Advanced Properties
Duplicate Record Exception Transformation
Duplicate Record Exception Transformation Overview
Duplicate Record Exception Process Flow
Duplicate Record Exceptions
Duplicate Record Exception Configuration View
Generating a Duplicate Records Table
Ports
Duplicate Record Exception Transformation Input Ports
Duplicate Record Exception Transformation Output Ports
Creating Ports
Duplicate Record Exception Transformation Advanced Properties
Duplicate Record Exception Mapping Example
Duplicate Record Exception Mapping
Match Transformation
Duplicate Record Exception Input Groups
Duplicate Record Exception Example Configuration View
Standard Output Table Records
Cluster Output
Creating a Duplicate Record Exception Transformation
Expression Transformation
Expression Transformation Overview
Expression Transformation Ports
Test Expressions
Date Format Strings for Sample Data
Testing an Expression
Port Selectors
Port Selector Configuration
Selection Rules
Creating a Port Selector
Windowing
Windowing Configuration
Dynamic Expressions
Output Port Settings
Creating a Dynamic Expression
Expression Transformation Advanced Properties
Filter Transformation
Filter Transformation Overview
Filter Transformations in Dynamic Mappings
Filter Condition
Parameterize the Filter Condition
Filtering Rows with Null Values
Filter Transformation Advanced Properties
Filter Transformation Performance Tips
Hierarchical to Relational Transformation
Hierarchical to Relational Transformation Overview
Example - Hierarchical to Relational Transformation
Output Relational Ports and the Overview View
Hierarchical to Relational Transformation Ports
Schema References
Port Configuration
Hierarchical to Relational Transformation Development
Creating the Hierarchical to Relational Transformation
Configuring the Ports and Mapping
Testing the Transformation
Java Transformation
Java Transformation Overview
Reusable and Non-Reusable Java Transformations
Active and Passive Java Transformations
Data Type Conversion
Complex Data Type Conversion on the Spark Engine
Designing a Java Transformation
Java Transformation Ports
Creating Ports
Setting Default Port Values
Java Transformation Advanced Properties
Configuring the Classpath for the Developer Tool Client
Configuring the Classpath for the Data Integration Service
Developing Java Code
Creating Java Code Snippets
Importing Java Packages
Defining Helper Code
Java Transformation Java Properties
Imports Tab
Helpers Tab
On Input Tab
At End Tab
Functions Tab
Full Code Tab
Filter Optimization with the Java Transformation
Early Selection Optimization with the Java Transformation
Push-Into Optimization with the Java Transformation
Creating a Java Transformation
Creating a Reusable Java Transformation
Creating a Non-Reusable Java Transformation
Compiling a Java Transformation
Troubleshooting a Java Transformation
Finding the Source of Compilation Errors
Identifying the Source of Compilation Errors
Converting to Struct Data Example
Java Transformation API Reference
Java Transformation API Methods Overview
defineJExpression
failSession
generateRow
getInRowType
getMetadata
incrementErrorCount
invokeJExpression
isNull
logError
logInfo
resetNotification
setNull
storeMetadata
Java Expressions
Java Expressions Overview
Expression Function Types
Using the Define Function Dialog Box to Define an Expression
Step 1. Configure the Function
Step 2. Create and Validate the Expression
Step 3. Generate Java Code for the Expression
Creating an Expression and Generating Java Code by Using the Define Function Dialog Box
Java Expression Templates
Working with the Simple Interface
invokeJExpression
Simple Interface Example
Working with the Advanced Interface
Invoking an Expression with the Advanced Interface
Rules and Guidelines for Working with the Advanced Interface
EDataType Class
JExprParamMetadata Class
defineJExpression
JExpression Class
Advanced Interface Example
JExpression Class API Reference
getBytes
getDouble
getInt
getLong
getResultDataType
getResultMetadata
getStringBuffer
invoke
isResultNull
Joiner Transformation
Joiner Transformation Overview
Joiner Transformation Advanced Properties
Joiner Caches
Joiner Transformation Ports
Joiner Transformations in Dynamic Mappings
Port Selectors in a Joiner Transformation
Selection Rules
Creating a Port Selector
Defining a Join Condition
Simple Condition Type
Advanced Condition Type
Port Selectors in Join Conditions
Dynamic Ports in Join Conditions
Expression Parameter
Join Types
Normal Join
Master Outer Join
Detail Outer Join
Full Outer Join
Sorted Input for a Joiner Transformation
Configuring the Sort Order
Adding Transformations to the Mapping
Rules and Guidelines for Join Conditions
Example of a Join Condition and Sort Order
Joining Data from the Same Source
Joining Two Branches of the Same Pipeline
Joining Two Instances of the Same Source
Guidelines for Joining Data from the Same Source
Blocking the Source Pipelines
Unsorted Joiner Transformation
Sorted Joiner Transformation
Joiner Transformation Performance Tips
Rules and Guidelines for a Joiner Transformation
Key Generator Transformation
Key Generator Transformation Overview
Soundex Strategy
Soundex Strategy Properties
String Strategy
String Strategy Properties
NYSIIS Strategy
Key Generator Output Ports
Configuring a Grouping Strategy
Key Creation Properties
Key Generator Transformation Advanced Properties
Labeler Transformation
Labeler Transformation Overview
When to Use a Labeler Transformation
Reference Data Use in the Labeler Transformation
Character Sets
Probabilistic Models
Reference Tables
Regular Expressions
Token Sets
Labeler Transformation Strategies
Character Labeling Operations
Token Labeling Operations
Labeler Transformation Ports
Character Labeling Properties
General Properties
Reference Table Properties
Character Set Properties
Filter Properties
Token Labeling Properties
General Properties
Token Set Properties
Custom Label Properties
Probabilistic Matching Properties
Reference Table Properties
Configuring a Character Labeling Strategy
Configuring a Token Labeling Strategy
Labeler Transformation Advanced Properties
Lookup Transformation
Lookup Transformation Overview
Connected and Unconnected Lookups
Connected Lookups
Unconnected Lookups
Developing a Lookup Transformation
Lookup Query
Default Lookup Query
SQL Override for a Lookup Query
Parameters in an SQL Override Query
Reserved Words
Guidelines for Overriding the Lookup Query
Overriding the Lookup Query
Lookup Source Filter
Filtering Source Rows in a Lookup
Lookup Condition
Configure the Lookup Condition
Rules and Guidelines for Lookup Transformation Conditions
Lookup Cache
Query Properties
Lookup Transformations in Dynamic Mappings
Define Dynamic Ports
Change the Lookup Source
Parameterize the Lookup Source
Lookup Sources that Contain Parameters
Configure Parameters in a Duplicate Data Object
Port Selectors
Port Selector Configuration
Selection Rules
Parameterize the Lookup Condition
Creating a Port Selector
Run-time Properties
Advanced Properties
Creating a Reusable Lookup Transformation
Creating a Non-Reusable Lookup Transformation
Creating an Unconnected Lookup Transformation
Unconnected Lookup Example
Lookup Caches
Lookup Caches Overview
Lookup Cache Types
Uncached Lookup
Static Lookup Cache
Persistent Lookup Cache
Rebuilding a Persistent Lookup Cache
Dynamic Lookup Cache
Shared Lookup Cache
Rules and Guidelines for Sharing a Lookup Cache
Cache Comparison
Cache Partitioning for Lookups
Dynamic Lookup Cache
Dynamic Lookup Cache Overview
Uses for a Dynamic Lookup Cache
Dynamic Lookup Cache Properties
Dynamic Lookup Cache and Output Values
Lookup Transformation Values
Lookup Transformation Values Example
SQL Override and Dynamic Lookup Cache
Mapping Configuration for a Dynamic Lookup Cache
Insert Else Update
Update Else Insert
Dynamic Lookup Cache and Target Synchronization
Conditional Dynamic Lookup Cache Updates
Conditional Dynamic Lookup Cache Processing
Configuring a Conditional Dynamic Lookup Cache
Dynamic Cache Update with Expression Results
Null Expression Values
Expression Processing
Configuring an Expression for Dynamic Cache Updates
Dynamic Lookup Cache Example
Rules and Guidelines for Dynamic Lookup Caches
Match Transformation
Match Transformation Overview
Match Analysis
Column Analysis
Single-Source Analysis and Dual-Source Analysis
Field Match Analysis and Identity Match Analysis
Groups in Match Analysis
Match Pairs and Clusters
Match Score Calculations
Weighted Scores
Null Match Scores
Cluster Output Options
Driver Scores and Link Scores in Cluster Analysis
Master Data Analysis
Mapping Reuse
Identity Match Analysis and Persistent Index Data
Rules and Guidelines for Persistent Index Data
Match Mapping Performance
Viewing Match Cluster Analysis Data
Viewing Match Performance Analysis Data
Match Performance in Identity Analysis
Creating a Data Store for Identity Index Data
Using the Index Data Store in Single-Source Analysis
Match Transformation Views
Match Transformation Ports
Match Transformation Input Ports
Match Transformation Output Ports
Persistence Status Codes and Persistence Status Descriptions
Output Ports and Match Output Selection
Match Mapplets
Creating a Match Mapplet
Using a Match Mapplet
Configuring a Match Analysis Operation
Match Transformations in Field Analysis
Field Match Analysis
Process Flow for Field Match Analysis
Field Match Type Options
Field Match Strategies
Field Match Algorithms
Field Match Strategy Properties
Field Match Output Options
Match Output Types
Match Output Properties
Field Match Advanced Properties
Field Match Analysis Example
Create the Mapping
Input Data Sample
Key Generator Transformation Configuration
Match Transformation Configuration
Run the Data Viewer
Conclusion
Match Transformations in Identity Analysis
Identity Match Analysis
Process Flow for Identity Match Analysis
Identity Match Type Properties
Index Directory and Cache Directory Properties
Persistence Method Parameters
Identity Match Strategies
Identity Match Algorithms
Identity Match Strategy Properties
Identity Match Output Options
Match Output Types
Match Output Properties
Identity Match Advanced Properties
Persistent Index Case Study
Identity Match Analysis Example
Create the Mapping
Input Data Sample
Expression Transformation Configuration
Match Transformation Configuration
Run the Data Viewer
Conclusion
Merge Transformation
Merge Transformation Overview
Configuring a Merge Strategy
Merge Transformation Advanced Properties
Normalizer Transformation
Normalizer Transformation Overview
Multiple-Occurring Fields
Generated Column ID
Multiple-Occurring Records
Input Hierarchy Definition
Normalizer Transformation Input Ports
Flatten Fields
Normalizer Transformation Output Groups and Ports
Create an Output Group
Update an Output Group
Key Generation for Output Groups
Normalizer Transformation Advanced Properties
Generate First Level Output Groups
Creating a Normalizer Transformation
Creating a Normalizer Transformation from an Upstream Source
Normalizer Mapping Example
Normalizer Example Mapping
Normalizer Example Definition
Normalizer Example Input and Output Groups
Normalizer Example Mapping Output
Parser Transformation
Parser Transformation Overview
Parser Transformation Modes
When to Use a Parser Transformation
Reference Data Use in the Parser Transformation
Pattern Sets
Probabilistic Models
Reference Tables
Regular Expressions
Token Sets
Token Parsing Operations
Token Parsing Ports
Token Parsing Properties
General Properties
Probabilistic Model Properties
Reference Table Properties
Token Set Properties
Pattern-Based Parsing Mode
Pattern-Based Parsing Ports
Configuring a Token Parsing Strategy
Configuring a Pattern Parsing Strategy
Parser Transformation Advanced Properties
Python Transformation
Python Transformation Overview
Data Type Conversion
Data Types in Input and Output Ports
Python Transformation Setup Requirements
Install Python, JEP, and Third-Party Libraries
Configure Spark Execution Parameters
Python Transformation Ports
Python Transformation Advanced Properties
Python Transformation Components
Resource File
Python Code
Rules and Guidelines
Creating a Python Transformation
Creating a Reusable Python Transformation
Creating a Non-Reusable Python Transformation
Python Transformation Use Case
Rank Transformation
Rank Transformation Overview
Ranking String Values
Rank Transformation Properties
Rank Transformations in Dynamic Mappings
Rank Transformation Ports
Rank Index
Rank Port
Define Group By Ports
Group By Parameters
Rank Caches
Rank Transformation Advanced Properties
Read Transformation
Read Transformation Overview
Read Transformation Properties
General Properties
Data Object Properties
Query Properties
Run-Time Properties
Sources Properties
Advanced Properties
Synchronize Relational Data Objects
Change the Source Data Object
Parameterize the Read Transformation
Read Transformation Parameters
Constraints
Create a Read Transformation
Creating a Read Transformation in the Mapping Editor
Relational to Hierarchical Transformation
Relational to Hierarchical Transformation Overview
Example - Relational to Hierarchical Transformation
Input Relational Ports and the Overview View
Relational to Hierarchical Transformation Ports
Schema References
Relational to Hierarchical Transformation Development
Creating the Relational to Hierarchical Transformation
Creating the Ports
REST Web Service Consumer Transformation
REST Web Service Consumer Transformation Overview
REST Web Service Consumer Transformation Process
REST Web Service Consumer Transformation Configuration
Message Configuration
Resource Identification
HTTP Methods
HTTP Get Method
HTTP Post Method
HTTP Put Method
HTTP Delete Method
REST Web Service Consumer Transformation Ports
Input Ports
Output Ports
Pass-through Ports
Argument Ports
URL Ports
HTTP Header Ports
Cookie Ports
Output XML Ports
Response Code Ports
REST Web Service Consumer Transformation Input Mapping
Rules and Guidelines to Map Input Ports to Elements
Mapping Input Ports to the Method Input
REST Web Service Consumer Transformation Output Mapping
Rules and Guidelines to Map Elements to Output Ports
Customize View Options
Mapping the Method Output to Output Ports
REST Web Service Consumer Transformation Advanced Properties
REST Web Service Consumer Transformation Creation
Creating a REST Web Service Consumer Transformation
Parsing a JSON Response Message that Contains Arrays
Example JSON Response Message
Unnamed Arrays in a Response Message
Router Transformation
Router Transformation Overview
Router Transformations in Dynamic Mappings
Working with Groups
Input Group
Output Groups
Using Group Filter Conditions
Dynamic Ports in Group Filter Conditions
Parameterize the Group Filter
Adding Groups
Working with Ports
Connecting Router Transformations in a Mapping
Router Transformation Advanced Properties
Sequence Generator Transformation
Sequence Generator Transformation Overview
Sequence Generator Ports
Pass-Through Ports
NEXTVAL Port
Sequence Generator Transformation Properties
Start Value
End Value
Increment Value
Cycle Through a Range of Values
Reset
Maintain Row Order
Sequence Data Object
Creating a Sequence Data Object
Creating a Sequence Generator Transformation
Frequently Asked Questions
Sorter Transformation
Sorter Transformation Overview
Sorter Transformations in Dynamic Mappings
Developing a Sorter Transformation
Sorter Transformation Ports
Sort Tab
Configure Sort Keys
Parameterize the Sort Keys
Sorter Transformation Advanced Properties
Sorter Cache
Optimizing the Sorter Cache
Creating a Sorter Transformation
Creating a Reusable Sorter Transformation
Creating a Non-Reusable Sorter Transformation
Sorter Transformation Example
SQL Transformation
SQL Transformation Overview
SQL Transformation Ports
Input Ports
Output Ports
Pass-through Ports
SQLError Port
Number of Rows Affected
SQL Transformation Advanced Properties
SQL Transformation Query
Define the SQL Query
Input Row to Output Row Cardinality
Query Statement Processing
Port Configuration
Maximum Output Row Count
Error Rows
Continue on SQL Error
Filter Optimization with the SQL Transformation
Early Selection Optimization with the SQL Transformation
Push-Into Optimization with the SQL Transformation
SQL Transformation Example with an SQL Query
Logical Data Object Mapping
Salary Table
Employee Table
SQL Transformation
Output
Stored Procedures
SQL Transformation Ports for Stored Procedures
Stored Procedure Result Sets
Stored Procedure Example
Result Sets with Different Databases
Result Set Rows
SQL Transformation Connection
Creating a Connection Name Parameter
Manually Creating an SQL Transformation
Creating an SQL Transformation from a Stored Procedure
Standardizer Transformation
Standardizer Transformation Overview
Standardization Strategies
Standardization Properties
Configuring a Standardization Strategy
Standardizer Transformation Advanced Properties
Union Transformation
Union Transformation Overview
Groups and Ports
Union Transformation Advanced Properties
Union Transformation Processing
Creating a Union Transformation
Creating a Reusable Union Transformation
Creating a Non-Reusable Union Transformation
Update Strategy Transformation
Update Strategy Transformation Overview
Setting the Update Strategy
Update Strategy Transformations in Dynamic Mappings
Flagging Rows Within a Mapping
Update Strategy Expressions
Update Strategy Transformation Advanced Properties
Aggregator and Update Strategy Transformations
Specifying Update Options for Individual Targets
Web Service Consumer Transformation
Web Service Consumer Transformation Overview
SOAP Messages
WSDL Files
Operations
Web Service Security
WSDL Selection
Web Service Consumer Transformation Ports
HTTP Header Input Ports
Other Input Ports
Web Service Consumer Transformation Input Mapping
Rules and Guidelines to Map Input Ports to Nodes
Customize View Options
Mapping Input Ports to the Operation Input
Web Service Consumer Transformation Output Mapping
Rules and Guidelines to Map Nodes to Output Ports
Mapping the SOAP Message as XML
Customize View Options
Mapping the Operation Output to Output Ports
Web Service Consumer Transformation Advanced Properties
Web Service Error Handling
Message Compression
Concurrency
Filter Optimizations
Enabling Early Selection Optimization with the Web Service Consumer Transformation
Push-Into Optimization with the Web Service Consumer Transformation
Creating a Web Service Consumer Transformation
Web Service Consumer Transformation Example
Input File
Logical Data Object Model
Logical Data Object Mapping
Web Service Consumer Transformation
Parsing Web Service SOAP Messages
Parsing Web Service SOAP Message Overview
Transformation User Interface
Multiple-Occurring Output Configuration
Normalized Relational Output
Generated Keys
Denormalized Relational Output
Pivoted Relational Output
Parsing anyType Elements
Parsing Derived Types
Parsing QName Elements
Parsing Substitution Groups
Parsing XML Constructs in SOAP Messages
Choice Element
List Element
Union Element
Generating Web Service SOAP Messages
Generating Web Service SOAP Messages Overview
Transformation User Interface
Input Ports Area
Operation Area
Port and Hierarchy Level Relationships
Keys
Map Ports
Map a Port
Map a Group
Map Multiple Ports
Pivoting Multiple-Occurring Ports
Map Denormalized Data
Derived Types and Element Substitution
Generating Derived Types
Generating anyType Elements and Attributes
Generating Substitution Groups
Generating XML Constructs in SOAP Messages
Choice Element
List Element
Union Element
Weighted Average Transformation
Weighted Average Transformation Overview
Configuring a Weighted Average Transformation
Weighted Match Scores Example
Weighted Average Transformation Advanced Properties
Write Transformation
Write Transformation Overview
Write Transformation Properties
General Properties
Data Object Properties
Ports Properties
Run-Time Properties
Run-time Linking Properties
Advanced Properties
Create a Write Transformation
Creating a Write Transformation from a Data Object
Creating a Write Transformation from Mapping Flow
Creating a Write Transformation from a Parameter
Creating a Write Transformation from an Existing Transformation
Transformation Delimiters
Transformation Delimiters Overview
Preface
Transformation Delimiters Overview
wizardFirstPageNewTransformation
preferenceDataHandlerPage
propertyDependenciesMultiInstanceTx
dialogStrategyPortsMultiInstanceTx
dialogExpressionEditor
dialogAddTransformationMapping
HIDD_WIDGETEDITOR_TAB2_TD
dialogChangePropagateMapping
ObjectAvTx
propertyTemplateAvTx
wizardAvTx
propertyConfigurationAvTx
propertyAvTx
dialogPreferenceContentStatusPage
dialogFieldConfigAvTx
propertyReportAvTx
dialogCustom3AvTx
ObjectAggregatorTx
propertyAggregatorTx
ObjectAssociationTx
propertyAssociationTx
ObjectExceptionTx
wizardConfigurationExceptionTx
propertyConfigurationExceptionTx
ObjectCaseConverterTx
wizardCaseConverterTx
propertyCasingCaseConverterTx
dialogCaseConverterStrategyProperties
propertyCaseConverterTx
propertyClassifierTx
dialogClassifierPropertiesDialog
ObjectClassifierTx
classifierOperationSelectionPage
propertyConfigurationCompositeComparison
propertyConfigurationStringDistanceTx
ObjectStringDistanceTx
propertyStringDistanceTx
wizardStringDistanceTx
ObjectConsolidationTx
WizardIDMTx
DialogDefaultIDMTx
RandomIDMTx
HIDD_MASK_STRING_DIALOG
HIDD_MASK_DATE_DIALOG
KeyIDMTx
HIDD_MASK_NUMERIC_DIALOG
CCIDMTx
EmailIDMTx
IPIDMTx
PhoneIDMTx
SSNIDMTx
URLIDMTx
SINIDMTx
propertyDecisionTx
wizardDesicionTx
ObjectDecisionTx
propertyDecisionSectionTx
dialogDecisionStrategy
dialogEditDecisionOutputsDialog
ObjectExpressionTx
dialogMacroExpressionEditor
dialogOutputPortSettings
ObjectFilterTx
extractor_DTRSelect
extractor_DTRAddExisting
extractor_Overview
extractor_Reference
wizardNameLocationPageNewJavaTx
ObjectJavaTx
ObjectJoinerTx
propertyConfigurationGroupTx
ObjectGroupTx
propertyGroupTx
propertyLabelerTx
propertyConfigurationLabelerTx
propertyConfigurationParameter
ObjectLabelerTx
dialogSourcePickerLookupTx
wizardNameLocationPageRelationalLookup
wizardNameLocationPageLogicalDataObjectLookup
wizardNameLocationPageNewFlatFileDataObjectLookup
wizardNameLocationPageRefTableLookup
ObjectLookupTx
parameterizedDataObjectDialog
dialogExistingMatchMappletMatcherTx
dialogExternalEnginePropertiesMatcherTx
dialogJaroEngineMatcherTx
dialogMatchFieldsMatcherTx
dialogStrategyMatcherTx
dialogIdentityEngineMatcherTx
propertyScoringMatcherTx
propertyClusterOptionsMatcherTx
ObjectMatcherTx
propertyPairGenOptionsMatcherTx
propertyMatcherTx
matcherTxWizardVanillaEngine
matcherTxWizardIdentityEngine
matcherTxWizardJaroEngine
matcherWizardMatchStrategy
wizardMatchFields
matcherWizardStrategySelection
propertyMergeJoinCharComposite
MergeTxCustomDelimitersDialog
propertyMergeMergeTx
ObjectMergeTx
wizardMergeTx
propertyMergeTx
wizardNormalizerTxPage
normalizerports
normalizerdefinition
newnormalizeroutputgroup
ObjectNormalizerTx
ObjectParserTx
wizardConfigurationParserTx
wizardNewParserTx
propertyConfigurationParserTx
dialogParserStrategyOutputs
parserOperationSelectionPage
TokenParserOperationDialog
CreateRegularExpressionDialog
dialogParserStrategyProperties
editProbabilisticParserDialog
dialogParseUsingTokenDefinition
PatternParserOperationDialog
TokenParserReferenceTableOperationDialog
TokenParserTokenSetOperationDialog
ObjectPythonTx
ObjectRankTx
propertyRankTx
PropertiesSectionSourceTx
injector_DTRSelect
injector_DTRAddExisting
injector_Overview
injector_Reference
ObjectRouterTx
SequenceObjectPickerPage
HIDD_SEQUENCE_PORTS
HIDD_SEQUENCE_PROPERTIES
ObjectSequenceTx
sequenceTxDetailsPage
createSequenceDataObj
createSequenceGenTx
ObjectSorterTx
propertySorterTx
ObjectSQLTx
propertyStandardizationTokenStandardiserTx
ObjectTokenStandardiserTx
propertyTokenStandardizerTx
ObjectUnionTx
ObjectUpdateStrategyTx
ObjectWSCTx
dialogNameValueInput
dialogWSCOtherPortsAction
wizardInputWSC
wizardOutputWSC
dialogHDPCustomizeView
wizardWSDLPickerPageWSC
wizardOperationPickerPageWSC
dialogHGroupSelection
dialogR2HKeyLocation
dialogR2HLocation
dialogHDPLocationPicker
dialogR2HPivotingOptionsDialog
H2RPivotingOptionsDialog
dialogDerivedTypePicker
ObjectWeightBasedAnalyserTx
propertyWBATx
PropertiesSectionTargetTx
workbench_window_context
com_informatica_adapter_hdfs_ComplexFile_wizardHSDFAddTargetPage
dialogTransformationDelimiters
preferenceDelimiterPage