Informatica 10.2 Developer Mapping Guide (English) IN 102 En
User Manual:
Open the PDF directly: View PDF
Page Count: 276 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Table of Contents
- Preface
- Chapter 1: Introduction to Mappings
- Chapter 2: Mapplets
- Chapter 3: Mapping Parameters
- Mapping Parameters Overview
- System Parameters
- User-Defined Parameters
- Where to Create User-Defined Parameters
- Where to Assign Parameters
- Parameters in Mappings
- Parameters in Mapplets
- Parameters in Logical Data Objects
- Parameters in Virtual Table Mappings
- Parameter Sets
- Parameter Files
- How to Configure Parameters
- Chapter 4: Mapping Outputs
- Chapter 5: Generate a Mapping from an SQL Query
- Chapter 6: Dynamic Mappings
- Chapter 7: How to Develop and Run a Dynamic Mapping
- Developing and Running Dynamic Mappings
- Configuring a Dynamic Source
- Creating a Dynamic Port
- Configuring Dynamic Ports Using Input Rules
- Step 1. Open the Input Rules Dialog box
- Step 2. Define Input Rules
- Step 2a. Choose the Operator and Selection Criteria
- Step 2b. Configure the Name Selection Criteria Details
- Step 2c. Configure the Type Selection Criteria Details
- Step 2d. Configure the Pattern Selection Criteria Details
- Step 3. Rename the Generated Ports
- Step 4. Reorder the Generated Ports
- Step 5. Verify the Dynamic Port Configuration
- Creating a Port Selector
- Creating a Dynamic Expression
- Configuring a Dynamic Target
- Creating and Configuring a Run-time Link
- Validating and Running a Dynamic Mapping
- Chapter 8: Dynamic Mapping Use Cases
- Use Case: Dynamic Mapping for Metadata Changes in Relational Sources
- Source Tables
- Target Table
- Dynamic Mapping
- Step 1. Configure the Read Transformations
- Step 2. Configure the Joiner Transformation
- Step 3. Configure the Aggregator Transformation
- Step 4. Configure the Write Transformation
- Step 5. Create and Configure a Run-time Link
- Step 6. Validate and Run the Mapping
- Step 7. Run the Mapping after Changes to the Source Schema
- Use Case: Reuse Dynamic Mapping for Different Sources and Targets
- Source Files
- Target Files
- Dynamic Mapping
- Step 1. Configure the Read_Customer_FF Read Transformation
- Step 2. Configure the Exp_TRIM Expression Transformation
- Step 3. Configure the Exp_Output Expression Transformation
- Step 4. Configure the Write_customerTrim_FF Write Transformation
- Step 5. Validate and Save the Mapping
- Step 6. Run the Dynamic Mapping Against Different Sources and Targets
- Use Case: Dynamic Mapping for Metadata Changes in Relational Sources
- Chapter 9: Mapping Administration
- Chapter 10: Export to PowerCenter
- Chapter 11: Import From PowerCenter
- Chapter 12: Performance Tuning
- Chapter 13: Pushdown Optimization
- Chapter 14: Partitioned Mappings
- Partitioned Mappings Overview
- One Thread for Each Pipeline Stage
- Multiple Threads for Each Pipeline Stage
- Partitioned Flat File Sources
- Partitioned Relational Sources
- Partitioned Flat File Targets
- Partitioned Relational Targets
- Partitioned Transformations
- Maintain Order in a Partitioned Mapping
- Override the Maximum Parallelism for a Mapping
- Troubleshooting Partitioned Mappings
- Chapter 15: Developer Tool Naming Conventions
- Index