Developer Mapping Guide

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

Back Next

Create a Dynamic Port and Define a Dynamic Expression

Create a dynamic port as an output-only port in the Exp_TRIM transformation. Define a dynamic expression to remove the spaces in the beginning and end of the strings.

In the

Properties

view of the Exp_TRIM transformation, click the

Ports

tab.

Click

New Dynamic Port

The Ports tab lists the ports in the Expression transformation. The tab contains a New button to create new ports. The tab also shows Cut, Copy, Paste, Delete, Move Up, and Move Down buttons.

Clear the

Input

column to make this port an output-only port.

Rename the dynamic port that you created as

Dynamic_TRIM

In the

Expression

column for the

Dynamic_TRIM

dynamic port, click the

Open

button (

The

Dynamic Expression

window opens.

Replace the existing expression in the editor with the following expression:

LTRIM(RTRIM(From_Read_Customer_FF))

The Ports tab in the Dynamic Expression dialog box lists the ports in the Expression transformation. The Expression editor shows the expression that you entered. The dialog box has an Output Port Settings area where you can configure the output ports.

Click

Validate

to validate the expression.

Click

to exit the

Validate Expression

dialog box.

Rename the output ports for the expression as follows:

In the

Output Port Settings

area, select the Base Port as From_Read_Customer_FF.

Click

Edit Output Port Settings

The

Output Port Settings

dialog box appears.

In the

Name

list, select

Base port name + Suffix

In the

Suffix

box, enter

_TRIM

Click

to exit the

Dynamic Expression

editor.

The following image shows the

Dynamic_TRIM

dynamic port with the renamed generated ports:

The mapping contains a Read transformation and an Expression transformation. The Expression transformation has two dynamic ports, From_Read_Customer_FF dynamic port and Dynamic_TRIM. The generated ports in the Dynamic_TRIM dynamic port have a _TRIM suffix.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Create a Dynamic Port and Define a Dynamic Expression

Create a Dynamic Port and Define a Dynamic Expression