Mappings
Mapping Designer
Mapping Configuration
Mapping Validation and Error Handling
Run Mapping
Mapping Updates and Deployment
Rules and Guidelines for Mapping Configuration
Configuring a Mapping
Mapping Tutorial
Preparing for the Mapping Tutorial
Step 1. Create a Mapping
Step 2. Configure a Source
Step 3. Create a Filter Transformation
Step 4. Configure a Target
Step 5. Validate the Mapping
Step 6. Create a Task
Mapping Maintenance
Flat Files
Fixed-Width File Formats
Configuring a Fixed-Width File Format
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
Field Expressions
Validating Expressions in Field Mappings
Transformation Language Components for Expressions
Expression Syntax
String and Numeric Literals
Rules and Guidelines for Expressions
Adding Comments to Expressions
Reserved Words
Parameters
Input Parameters
Input Parameter Types
Input Parameter Configuration
Partial Parameterization with Input Parameters
In-Out Parameters
Aggregation Types
Variable Functions
In-Out Parameter Properties
In-Out Parameter Values
Rules and Guidelines for In-Out Parameters
Creating an In-Out Parameter
Editing In-Out Parameters in a Mapping Configuration Task
In-Out Parameters Example
Parameter Files
Expression Macros
Macro Types
Macro Input Fields
Vertical Macros
Configuring a Vertical Macro
Vertical Macro Example
Horizontal Macros
Horizontal Expansion Functions
Configuring a Horizontal Macro
Horizontal Macro Example
Hybrid Macros
Partitions
Partitioning Rules and Guidelines
Partitioning Examples
Bundles
Bundle Types
Installing a Bundle
Viewing a Bundle
Working with Installed Bundles
Copying a Bundle to the Organization
Creating a Mapping Configuration Task from a Bundle
Uninstalling a Bundle
Upgrading a Bundle
Bundle Design
Creating a Bundle
Working with Bundle Designs
Publishing a Private Bundle to Sub-Organizations
Generating a Bundle Access Code for Unlisted Bundles
Submitting a Public Bundle for Review
Mapplets
Active and Passive Mapplets
Stored Procedures in Mapplets
PowerCenter XML Files for Mapplets
Mapplets in Informatica Cloud Tasks
Configuring a Mapplet
Saved Queries
Saved Query Syntax
Rules and Guidelines for Creating a Saved Query
Using Saved Queries in Data Synchronization Tasks
Configuring a Saved Query
Integration Templates
Prerequisites
Step 1. Configure an Integration Template
Creating an Integration Template
Integration Template Information in Tasks
Template Parameters
Expression Macros in Integration Templates
Parameter Files and User-Defined Parameters
Object-Level Session Properties
Optional Objects
Rules and Guidelines for Configuring an Integration Template
Step 2. Publish the Integration Template
Step 3. Import an Integration Template and Configure Template Parameter Properties
Logical Connections
Input Control Options
Parameter Display Customization
Advanced Session Properties
Pushdown Optimization
Importing or Editing an Integration Template
Example - Date Conversion
Example Step 1. Configure and Publish the Date To String Integration Template
Example Step 2. Import the Date To String Integration Template
Example Step 3. Create the Mapping Configuration Task
Viewing Integration Template Details
Creating a Mapping Configuration Task from an Integration Template
Downloading Template XML
Deleting an Integration Template
Mappings
Deleting an Integration Template
MAPPING_LIST_PAGE
MAPPING_DESIGNER
CMD_PROP_SECTION_TGT_FIELD_MAPPING
FWCONFIGS_PAGE
EDIT_FWCONFIG_PAGE
DI_WIZ_FIELDEXPRESSION_PAGE
CMD_EXPRESSION_DIALOG
CMD_PARAMETER_DIALOG
CMD_VARIABLE_DIALOG
MTT_WIZ_SET_IN_OUT_PARAMETERS
CMD_PROP_SECTION_SRC_PARTITIONING
INSTALLED_BUNDLE_VIEW_PAGE
BUNDLE_PAGE
CUSTOMFUNCS_PAGE
VIEW_CUSTOMFUNC_PAGE
EDIT_CUSTOMFUNC_PAGE
CUSTOMSOURCES_PAGE
VIEW_CUSTOMSOURCE_PAGE
SAVED_QUERY_PAGE
EDIT_CUSTOMSOURCE_PAGE
TEMPLATES_PAGE
CREATE_EDIT_TEMPLATE_PAGE
VIEW_TEMPLATE_PAGE