Developer Mapping Guide

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

Back Next

Step 1. Create the Mapping and Configure Mapping Parameters

Create a mapping with an Expression transformation that writes to a local flat file target. Define input parameters for the mapping.

Create a mapping to process data from a MOVIES file. Use a Read transformation to read from the data source.

Include an Expression transformation immediately after the source. The Expression transformation includes an expression to aggregate the output value.

Use a Write transformation to write the result to a local flat file target.

The following image shows the mapping: The editor shows a mapping that includes a Read transformation, Expression transformation, and Write transformation. The mapping reads from a file called MOVIES and writes to a flat file.

The editor shows a mapping that includes a Read transformation, Expression transformation, and Write transformation. The mapping reads from a file called MOVIES and writes to a flat file.

Click the editor to access the mapping properties.

Open the

Parameters

view.

Create a parameter that will accept the persisted mapping output value called col_id_val. Set a default value for the parameter.

Create a parameter for the name of the ID column in the source table called col_id_name.

The following image shows the mapping parameters: The Parameters view shows the two mapping parameters, col_id_val and col_id_name. col_id_val has the type 'double', precision set to 15, scale set to 0, and default value set to 0.0. col_id_name has the type 'string', precision set to 1000, scale set to 0, and default value set to 'id2.'

The Parameters view shows the two mapping parameters, col_id_val and col_id_name. col_id_val has the type 'double', precision set to 15, scale set to 0, and default value set to 0.0. col_id_name has the type 'string', precision set to 1000, scale set to 0, and default value set to 'id2.'

Create a parameter set that includes the col_id_name parameter. Set the value for the parameter to MOVIES.ID.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Step 1. Create the Mapping and Configure Mapping Parameters

Step 1. Create the Mapping and Configure Mapping Parameters