Preface
Mappings
Mapplets
Mapping Parameters
Mapping Outputs
Generate a Mapping from an SQL Query
Dynamic Mappings
How to Develop and Run a Dynamic Mapping
Dynamic Mapping Use Cases
- Use Case: Dynamic Mapping for Metadata Changes in Relational Sources
- Use Case: Reuse Dynamic Mapping for Different Sources and Targets
Mapping Administration
Export to PowerCenter
Import From PowerCenter
Performance Tuning
Pushdown Optimization
Partitioned Mappings
Developer Tool Naming Conventions

Developer Mapping Guide

10.2.1
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2

Back Next

Step 2. Configure the Exp_TRIM Expression Transformation

Add an Expression transformation Exp_TRIM to the mapping and configure the transformation to remove the spaces in the beginning and end of the strings.

Create a dynamic port to receive columns from the Read transformation and define input rules to include only the string ports.

Create a dynamic output port and define a dynamic expression to remove the spaces in the beginning and end of the strings.

Use Case: Reuse Dynamic Mapping for Different Sources and Targets

Create a Dynamic Port and Define Input Rules

Create a Dynamic Port and Define a Dynamic Expression

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Step 2. Configure the Exp_TRIM Expression Transformation

Step 2. Configure the Exp_TRIM Expression Transformation