- Data Integration
- All Products
Add Field icon
Adds a field from the selected lookup object. Use to retrieve a field from the object that does not display in the list.
New Fielddialog box. Enter the exact field name, data type, precision, and scale, and click
Deletes the field from the list, removing the field from the data flow.
Sorts fields in native order, ascending order, or descending order.
Enter a search string to find the fields with names that contain the string.
Contains the following options:
Synchronizes the list of fields with the lookup object.
If you select this option, you lose any changes you make to the metadata for return fields.
Ignore in Comparison
When the transformation uses a dynamic cache, by default,
Data Integrationcompares the values in all lookup fields with the values in the associated incoming fields to determine whether to update the row in the lookup cache.
Enable this property if you want
Data Integrationto ignore the field when it compares the values before updating a row. You must configure the transformation to compare at least one field.
This property is displayed for each field when the Lookup transformation uses a dynamic cache.
Retain existing fields at runtime
If field metadata changes after a mapping is saved,
Data Integrationuses the updated field metadata when you run the mapping. Typically, this is the desired behavior. However, if the mapping uses a native flat file connection and you want to retain the metadata used at design time, enable the
Retain existing fields at runtimeoption. When you enable this option,
Data Integrationmapping tasks will use the field metadata that was used when you created the mapping.
Updated March 06, 2023