page displays differently depending on the basis for the task. If the mapping does not contain input parameters, the page doesn't display.
The
Input Parameters
page displays input parameters such as filter and lookup conditions, field mappings, and expressions. It also displays stored procedure connections. It doesn't display source, target, or lookup connections and objects.
Configure the parameters that display.
Depending on the mapping data flow, you might need to configure some parameters before you configure other parameters. For more information, see
Mappings
.
If the mapping contains a filter parameter, the task might display as valid even if you haven't configured the filter value. You must configure all parameters before the task is valid and you can run it.
If necessary, configure stored procedure details.
This displays when a stored procedure requires a connection. Select a connection or optionally create a new one.
If necessary, configure lookup conditions.
This displays when the lookup condition is parameterized.
If necessary, configure mapplet details.
This displays when a mapplet requires a connection and the mapplet is configured to display on this page.
For some connection types, you can select
Display technical field names instead of labels
to display technical names instead of business names.
To display fields in alphabetical order, click
Display mapplet fields in alphabetical order
.
If necessary, configure field mappings.
This displays when the field mapping is parameterized. Use the
Object
list to display fields from different objects.
Map fields in one of the following ways:
To automatically map fields with the same name, click
Automap
Exact Field Name
. Or, to map fields with similar names, click
Automap
Smart Map
.
You can undo all automapped field mappings by clicking
Smart Map
Undo Automap
. To unmap a single field, select the field to unmap and click
Actions
Unmap
.
To manually map fields, select and drag the source fields to the applicable target fields.