Transformations
Active and Passive Transformations
Transformation Types
Incoming Fields
Field Name Conflicts
Field Rules
Variable Fields
Multibyte Hierarchical Data
Source Transformation
Source Properties
File Source Properties
Database Source Properties
Web Service Sources
Web Service Operations for Sources
Request Messages
Field Mapping for Web Service Sources
Multibyte Hierarchical Data
Related Objects
Joining Related Objects
Source Queries
Source Fields
Source Field Options
Target Transformation
Target Transformation Properties
Defining the Target Object
Flat File Target Time Stamps
Specifying Target Properties
Update Columns for Relational Targets
Configuring Update Columns
Target Properties
Database Target Properties
File Target Properties
Web Service Targets
Web Service Operations for Targets
Field Mapping for Web Service Targets
Multibyte Hierarchical Data
Target Fields
Target Field Options
Target Transformation Field Mappings
Aggregator Transformation
Group By Fields
Sorted Data
Aggregate Fields
Aggregate Functions
Nested Aggregate Functions
Conditional Clauses
Data Masking Transformation
Masking Techniques
Configuration Properties for Masking Techniques
Repeatable Output
Seed
Mask Format
Source Filter Characters
Target Filter Characters
Range
Blurring
Credit Card Masking
Email Masking
IP Address Masking
Key Masking
Phone Number Masking
Random Masking
Social Insurance Number Masking
Social Security Number Masking
Custom Substitution Masking
Substitution Masking
URL Address Masking
Mask Rule Parameter
Creating a Data Masking Transformation
Masking Transformation Example
Expression Transformation
Expression Fields
Filter Transformation
Filter Conditions
Hierarchy Builder Transformation
Using a Hierarchy Builder Transformation
Hierarchical Schemas
Creating a Hierarchical Schema
Sample or Schema
Output Settings
Selecting a Hierarchical Schema
Creating a Hierarchical Schema from Sample
Field Mapping
Selecting a Primary or Foreign Key
Selecting the Fields to Map
Multibyte Hierarchical Data
Hierarchy Builder Example
Hierarchy Parser Transformation
Using a Hierarchy Parser Transformation
Hierarchical Schemas
Creating a Hierarchical Schema
Sample or Schema
Hierarchical Data Limitations
Input Settings
Selecting a Hierarchical Schema
Creating a Hierarchical Schema from Sample
Input Field Selection
Field Mapping
Selecting the Elements to Convert
Output Fields
Selecting an Output Group
Multibyte Hierarchical Data
Hierarchy Parser Transformation Example
Joiner Transformation
Join Condition
Join Type
Creating a Joiner Transformation
Lookup Transformation
Lookup Object
Lookup Condition
Lookup Return Fields
Advanced Properties
Lookup Query Overrides
Lookup Example
Unconnected Lookups
Configuring an Unconnected Lookup Transformation
Calling an Unconnected Lookup from Another Transformation
Unconnected Lookup Example
Mapplet Transformation
Mapplet Transformation Use
Selecting a Mapplet
Mapplet Transformation Field Mappings
Mapplet Transformation Output Fields
Creating a Mapplet Transformation
Normalizer Transformation
Normalized Fields
Occurs Configuration
Unmatched Groups of Multiple-Occurring Fields
Generated Keys
Normalizer Field Mapping
Normalizer Field Mapping Options
Target Configuration for Normalizer Transformations
Normalizer Field Rule for Parameterized Sources
Mapping Example with a Normalizer and Aggregator
Router Transformation
Working with Groups
Guidelines for Connecting Output Groups
Group Filter Conditions
Router Transformation Examples
Sequence Generator Transformation
Sequence Generator Transformation Uses
Sequence Generator Output Fields
Sequence Generator Properties
Sequence Generator Transformation Rules and Guidelines
Sequence Generator Transformation Example
Sorter Transformation
Sort Conditions
Sorter Caches
Sorter Transformation Advanced Properties
Sorter Transformation Example
SQL Transformation
SQL Transformation Configuration
Selecting a Stored Procedure or Function
SQL Transformation Field Mapping
SQL Transformation Output Fields
SQL Transformation Advanced Properties
SQL Transformation Example
Structure Parser Transformation
Using a Structure Parser Transformation
Intelligent Structures
Creating an Intelligent Structure
Refining an Intelligent Structure
Editing an Intelligent Structure
Deleting an Intelligent Structure
Structure Parser
Selecting an Intelligent Structure
Structure Parser Field Mapping
Output Fields
Processing Input from a Complex File Connecter
Processing Input from a Flat File Source Transformation
Configuring the Flat File Source Transformation
Configuring the Structure Parser to Access Flat Files
Selecting an Output Group
Structure Parser Transformation Example
Troubleshooting
Union Transformation
Comparison to Joiner Transformation
Planning to Use a Union Transformation
Input Groups
Output Fields
Field Mappings
Union Transformation Example
Web Services Transformation
Step 1. Create a Web Services Consumer Connection
Step 2. Define a Business Service
Step 3. Configure the Web Services Transformation
Configuring the Transformation
Transaction Commit Control
Viewing Incoming and Request Fields
Pass-Through Fields
Web Services Transformation Example
Multibyte Hierarchical Data
Transformations
Multibyte Hierarchical Data
CMD_PROP_SECTION_TX
CMD_PROP_SECTION_TX_FIELDS
CMD_PROP_SECTION_SRC
CMD_FMAP_SECTION_SRC
CMD_PROP_SECTION_SRC_FIELDS
CMD_ADAPTER_FIELD_DIALOG
CMD_PROP_SECTION_TGT
DESIGNER_CREATE_TARGET
CMD_PROP_SECTION_TGT_FIELDS
CMD_PROP_SECTION_AGGREGATOR_GROUPBY
CMD_PROP_SECTION_AGGREGATOR
CMD_FIELD_DIALOG
HIDD_DATAMASK_PORTS
HIDD_DATA_MASKING
CMD_PROP_SECTION_EXPRESSION
CMD_PROP_SECTION_FLTR_CONDITION
R2H_INPUT_PROPERTIES
R2H_FIELD_MAPPING
HSCHEMAS_PAGE
EDIT_HSCHEMA_PAGE
VIEW_HSCHEMA_PAGE
X2R_INPUT_PROPERTIES
X2R_INPUT_FIELD_MAPPING
X2R_FIELD_MAPPING
X2R_OUTPUT_FIELDS
HSCHEMA_OUTPUT_GROUPS
SELECT_OUTPUT_GROUPS
CMD_PROP_SECTION_JNR_CONDITION
CMD_PROP_SECTION_LKP
CMD_PROP_SECTION_LKP_CONDITION
CMD_PROP_SECTION_LKP_FIELDS
CMD_PROP_SECTION_MPLT
CMD_PROP_SECTION_MPLT_FIELD_MAPPING
CMD_PROP_SECTION_MPLT_FIELDS
CMD_PROP_SECTION_NORMALIZED_FIELDS
CMD_NORMALIZED_FIELD_DIALOG
CMD_PROP_SECTION_NORMALIZED_FIELD_MAPPING
CMD_PROP_SECTION_ROUTER_GROUPS
CMD_ROUTER_EDIT_GROUP_NAME_DIALOG
CMD_ROUTER_FILTER_CONDITION_DIALOG
CMD_PROP_SECTION_SG_SEQ
CMD_PROP_SECTION_SG_OUT_FIELDS
CMD_PROP_SECTION_SG_SEQ
CMD_PROP_SECTION_SORTER
CMD_PROP_SECTION_SQL
CMD_PROP_SECTION_SQL_FIELDS
CMD_PROP_SECTION_SQL_FIELD_MAPPING
STRPAR_GEN_PROP
VIEW_STRDEF_PAGE
STRPAR_SELECT
STRPAR_FIELD_MAP
STRPAR_OUT_FIELDS
CMD_PROP_SECTION_UNION_FIELDS
CMD_PROP_SECTION_UNION_FIELD_MAPPING
VIEW_BUSINESS_SERVICES_PAGE
EDIT_BUSINESS_SERVICE_PAGE
CMD_PROP_SECTION_HIERARCHY