Creating Constant Value Maps

Constant Value map returns a single, predefined value for all records.

To add a Constant Value map, drag the Constant Value object from the Maps group in the Flow toolbox and drop it on the dataflow.

An example of what a Constant Value object might look like is shown below.

../_images/image43.jpg

To configure the properties of a Constant Value map object after it was added to the dataflow, right-click on it and select Properties from the context menu. The following properties are available:

Constant Value: Enter the value that will be returned by this object.

General Options screen:

This screen shares the options common to most objects on the dataflow.

Usage

An example of a dataflow using Constant Value objects is shown below:

../_images/blobid0.png