Use the Assignment step to set a value to a field.
To create an Assignment step, click a process, and then select
Assignment
from the Design canvas. Then, from the Assignments properties panel, click the
Add
icon to assign Name and Assignment values.
The following image shows an Assignment step:
To add a field, click the
Add
icon, and then add the following information for each field:
Name
This is the fully-qualified field name. The name can contain only alphanumeric characters, underscores (_), spaces, and Unicode characters.
Assignments
This is the source from which the field takes values. The fields you see depend on the data type you defined
under
Start
Properties
Input Fields or Temporary Fields
.
For example, if you define the data type in the Input Fields as Date or Time, the following options appear for that field in the Assignment step:
Specific date
Days from today
Days before/after
Field
Formula
If you define the data type as Integer or Text, you see the following options to specify the
value of the field:
Content
. Select the
Content
option to enter a value or select a
field to set the value. Click
Insert Field
to
select the field.
Field
. Select the
Field
option to select a field and set the
value.
Hierarchical
Mapper
.
Select the
Hierarchical Mapper
option to choose
an existing hierarchical mapper to set the value. You can use a
hierarchical mapper to easily map fields between objects. You can create
a hierarchical mapper to map a hierarchical schema, such as the schema
for an industry-standard message, to another hierarchical schema. For
example, to convert a process object from one type to another, you’ll
need to manually map the fields. To avoid the manual effort, you can use
a hierarchical mapper. You can select an existing hierarchical mapper or
create a new one. You can select only XML or JSON schema types. You can
create a hierarchical mapper in
Data Integration
. For more information about hierarchical mappers, see
Components
in Data Integration.
Formula
. Select the
Formula
option to use a formula to override
the value. Use the
Expression Editor
to create a
formula with expressions.
Click
+
icon and select multiple fields simultaneously and automap them.
You can also map the fields automatically including complex process objects configured in the input fields or temporary fields in the process.
To map the fields automatically, add the fields and click
AutoMap
.
You must ensure that you have meaningful field names to find the most accurate field matches. If the field name that you want to match contains some random text, Application Integration does not recognize the field name and the mapping field remains empty.
Application Integration matches the best possible fields based on the field name and data type that are configured in the process. Informatica does not guarantee exact field matches. After the fields are mapped, you must manually verify if the mappings are correct and update as needed.
ASK INFAPreview
