Transformations
Active and passive transformations
Transformation types
Transformations available in mappings
Transformations available in SQL ELT mode
Incoming fields
Field name conflicts
Field rules
Data object preview
Variable fields
Transformation caches
Cache types
Cache files
Cache size
Optimizing the cache size
Expression macros
Macro types
Macro input fields
Vertical macros
Horizontal macros
Hybrid macros
File lists
Manually created file lists
File list commands
Using a file list in a Source transformation
Using a file list in a Lookup transformation
Configuration for multibyte hierarchical data
Source transformation
Source object
File sources
Database sources
Database source properties
Related objects
Advanced relationships
Custom queries
Source filtering and sorting
Configuration for multibyte hierarchical data
Source fields
Editing transformation data types
Target transformation
Target object
File targets
File target properties
Flat file targets created at run time
Flat file targets with static file names
Flat file targets with dynamic file names
Creating a flat file target at run time
Database targets
Database target properties
Database targets created at run time
Update columns for relational targets
Target update override
Configuration for multibyte hierarchical data
Target fields
Target transformation field mappings
Configuring a Target transformation
Aggregator transformation
Group by fields
Sorted data
Aggregate fields
Aggregate functions
Nested aggregate functions
Conditional clauses
Advanced properties
Aggregator transformation example
Expression transformation
Expression fields
Output fields
Variable fields
Input macro field
Output macro field
Expression editor
Transformation language components for expressions
Expression syntax
String and numeric literals
Adding comments to expressions
Reserved words
Advanced properties
Filter transformation
Filter conditions
Advanced properties
Input transformation
Input fields
Joiner transformation
Join condition
Join type
Advanced properties
Creating a Joiner transformation
Joiner transformation example
Lookup transformation
Lookup object
Lookup object properties
Custom queries
Lookup condition
Lookup return fields
Advanced properties
Lookup SQL overrides
Lookup SQL overrides for cached lookups
Lookup SQL override for uncached lookups
Guidelines for overriding the lookup query
Lookup source filter
Dynamic lookup cache
Static and dynamic lookup comparison
Dynamic cache updates
Inserts and updates for insert rows
Dynamic cache and lookup source synchronization
Dynamic cache and target synchronization
Field mapping
Ignore fields in comparison
Dynamic lookup query overrides
Persistent lookup cache
Rebuilding the lookup cache
Unconnected lookups
Configuring an unconnected Lookup transformation
Calling an unconnected lookup from another transformation
Connected Lookup example
Dynamic Lookup example
Unconnected Lookup example
Mapplet transformation
Mapplet transformation configuration
Selecting a mapplet
Mapplet transformation field mappings
Mapplet parameters
Mapplet transformation output fields
Mapplet transformation names
Synchronizing a mapplet
Normalizer transformation
Normalized fields
Occurs configuration
Field groups
Unmatched groups of multiple-occurring fields
Generated keys
Normalizer field mapping
Normalizer field mapping options
Advanced properties
Target configuration for Normalizer transformations
Normalizer field rule for parameterized sources
Mapping example with a Normalizer and Aggregator
Output transformation
Output fields
Generating output fields based on incoming fields
Field mapping
Rank transformation
Ranking string values
Rank caches
Defining a Rank transformation
Rank transformation fields
Defining rank properties
Defining rank groups
Advanced properties
Rank transformation example
Router transformation
Working with groups
Guidelines for connecting output groups
Group filter conditions
Configuring a group filter condition
Advanced properties
Router transformation examples
Sequence transformation
Sequence transformation uses
Sequence output fields
Sequence properties
Disabling incoming fields
Sequence transformation rules and guidelines
Sequence transformation example
Sorter transformation
Sort conditions
Sorter caches
Advanced properties
Sorter transformation example
SQL transformation
Stored procedure or function processing
Connected or unconnected SQL transformation for stored procedure processing
Unconnected SQL transformations
Calling an unconnected SQL transformation from an expression
Invoking a stored procedure before or after a mapping run
Stored procedure run order
Unconnected SQL transformation example
Query processing
Static SQL queries
Dynamic SQL queries
Passive mode configuration
SQL statements that you can use in queries
Rules and guidelines for query processing
SQL transformation configuration
Configuring the SQL type
SQL transformation field mapping
SQL transformation output fields
Advanced properties
Union transformation
Comparison to Joiner transformation
Planning to use a Union transformation
Input groups
Output fields
Field mappings
Advanced properties
Union Transformation example
Transformations
Union Transformation example
CMD_ADV_PROP
DI_TRANS_MOD_HYLNK
CMD_PROP_SECTION_TX
CMD_FIELD_NAME_CONFLICT_RESOLUTION_DIALOG
CMD_PROP_SECTION_TX_FIELDS
CMD_DATATYPE_RULE_DIALOG
CMD_ALL_RULE_DIALOG
CMD_PROP_SECTION_MPLT_INCOMING_FIELDS
CMD_NAME_RULE_DIALOG
CMD_DATA_PREVIEW_DIALOG
CMD_PROP_SECTION_SRC
CMD_FORMATING_OPTS_DIALOG
CMD_CUSTOM_QUERY_DIALOG
CMD_PROP_SECTION_SRC_FIELDS
CMD_ADAPTER_FIELD_DIALOG
CMD_PROP_SECTION_TGT
CMD_FORMATTING_OPTS_DIALOG_TGT
CMD_PROP_SECTION_TGT_FIELDS
DESIGNER_CREATE_TARGET
CMD_PROP_SECTION_AGGREGATOR_GROUPBY
CMD_PROP_SECTION_AGGREGATOR
CMD_FIELD_DIALOG
CMD_ADV_PROP_AGG
CMD_PROP_SECTION_EXPRESSION
CMD_ADV_PROP_EXP
CMD_PROP_SECTION_FLTR_CONDITION
CMD_FILTER_CONDITION_DIALOG
CMD_ADV_PROP_FIL
INPUT_PROP
INPUT_SECTION_INPUT_FIELDS
CMD_PROP_SECTION_JNR_CONDITION
CMD_ADV_PROP_JNR
CMD_PROP_SECTION_LKP
CMD_LKUP_CUSTOM_QUERY_DIALOG
CMD_PROP_SECTION_LKP_CONDITION
CMD_PROP_SECTION_LKP_FIELDS
CMD_ADV_PROP_LKP
HL_LOOKUP_SOURCE_FILTER
CMD_PROP_SECTION_LKP_INCOMING_FIELDS
CMD_PROP_SECTION_MPLT
CMD_SELECT_MAPPLET_DIALOG
CMD_PROP_SECTION_MPLT_FIELD_MAPPING
CMD_PROP_SECTION_MLPT_PARAM
CMD_PROP_SECTION_MPLT_FIELDS
CMD_PROP_SECTION_NORMALIZED_FIELDS
CMD_NORMALIZED_FIELD_DIALOG
CMD_NORMALIZED_FIELD_FROM_INCOMING_DIALOG
CMD_PROP_SECTION_NORMALIZED_FIELD_MAPPING
CMD_ADV_PROP_NRM
OUTPUT_PROP
OUTPUT_SECTION_OUTPUT_FIELDS
OUTPUT_SECTION_OUTPUT_FIELD_MAPPING
CMD_PROP_SECTION_RANK
CMD_GROUP_BY_RANK
CMD_ADV_PROP_RANK
CMD_PROP_SECTION_ROUTER_GROUPS
CMD_ROUTER_EDIT_GROUP_NAME_DIALOG
CMD_ROUTER_FILTER_CONDITION_DIALOG
CMD_ADV_PROP_RTR
CMD_PROP_SECTION_SG_SEQ
CMD_PROP_SECTION_SG_OUT_FIELDS
CMD_PROP_SECTION_SG_SEQ
CMD_ADV_PROP_SEQ
CMD_PROP_SECTION_SORTER
CMD_ADV_PROP_SRT
CMD_PROP_SECTION_SQL
STORED_PROC_EXEC_ORDER
DESIGNER_STORED_PROC_SEARCH
CMD_PROP_SECTION_SQL_FIELD_MAPPING
CMD_PROP_SECTION_SQL_FIELDS
CMD_ADV_PROP_SQL
CMD_PROP_SECTION_UNION_FIELDS
CMD_UNION_FIELD_SELECTION_DIALOG
CMD_UNION_FIELD_DIALOG
CMD_PROP_SECTION_UNION_FIELD_MAPPING
CMD_ADV_PROP_UNI