Source Fields

Edit field metadata.

You can edit the name of a field. You can also edit the metadata for a field. You might edit metadata to change information that is incorrectly inferred. When you edit metadata, you can change the name, native data type, native precision, and native scale. When you change the metadata for a field, you cannot easily revert your changes. Avoid making changes that can cause errors when you run the task.

For example, you can usually increase the native precision or native scale of a field without causing errors. But if you reduce the precision of a field, you might cause the truncation of data.

Add or remove fields.

You can add fields to a mapping source. When you add a field, you need field details, including the field name, data type, precision, and scale. If you are using a file list as the source, you might want to add the source file name to the field list so that you can identify the source for each target row.

You can also remove fields that you do not want to use in the mapping.

Restore original fields from the source object.

To restore the original fields from the source object, use the Synchronize option. When you synchronize fields, Informatica Cloud restores deleted source fields and adds fields that are new to the source. Informatica Cloud removes any added fields that do not have corresponding fields in the source object.

Informatica Cloud updates the metadata for existing source fields based on whether you synchronize all fields or synchronize new fields only. When you synchronize all fields, Informatica Cloud replaces any field metadata that you edited with the field metadata from the source object. When you synchronize new fields only, Informatica Cloud retains the metadata for any existing source field.

Source Field Options

Generate Fields From

Field name display option. Display field names by label or technical field name.

Sort Field Name By

Field order display option. Display fields in native order, ascending order, or descending order.

Add Field icon

Adds a field from the selected object. Use to retrieve a field from the object that does not display in the list.

Opens a dialog box where you can enter the exact field name, data type, precision, and scale.

Synchronize icon

Synchronizes the list of fields with the object.

Delete icon

Deletes the field from the list, removing the field from the data flow.

Edit Metadata

Displays the native field metadata. Check Edit Metadata if you want to change the native field metadata.

You can display the native field name by label or technical field name.

Add FileName Column to Table

Adds the CurrentlyProcessedFileName field to the fields table. Use when you use a file list as the source so that you can identify sources in the target table.