Oracle Cloud Infrastructure Documentation

Mapping Attributes

The Attribute mapping step is only available for data loader tasks that use existing target data entities.

When you specify existing target data entities for a data loader task, by default Data Integration uses attribute names to automatically map the attributes between the source and target entities.

You can add more mappings to map source entity attributes to target entity attributes. Mapping attributes is supported in data loader tasks that are configured with either the single entity or multiple entities load type.

To view the data entity attributes and their mappings:

  1. On the Create data loader task page, go to the Attribute mapping step.

    If the data loader task is configured for multiple entities load type, you might have to wait for the list of entities to display.

  2. For single data entity load type:

    A source entity table is displayed next to a target entity table.

    The total number of attributes in each entity, the number of mapped attributes, and the number of attributes without mappings, are shown in colored number icons above the tables.

    OptionDescription
    menu to filter attributes

    In both tables, all the attributes are shown by default. The menu above the Name column header indicates All.

    Use the menu to filter the list of attributes. You can choose to view only the Mapped attributes or Attributes not mapped.

    In the tables, an icon in the Mapping column indicates the type of attribute mapping. For example, Auto or Manual. You can place the cursor over a mapping to see the mapped attribute name.
    Search by name

    In the search field, enter a partial attribute name to filter the list quickly. For example, you can enter name to display the attributes FIRST_NAME and LAST_NAME.
    icon to collapse/expand list

    You can collapse and expand the lists by using the three dots icon above the Mapping column header.
    Map by name

    By default, the option is not enabled because the Map by name mapping is already added. Data Integration automatically adds the default mapping, which maps source entity attributes to target entity attributes by their attribute names.

    The option is enabled when the Map by name mapping is removed.
    Add pattern

    Use the option to add more mappings, either manually or by using a pattern.

    See:
    View mappings (1)

    Use the option to view all the mappings that have been added to the data loader task. The number in parentheses shows the number of mappings.

    See Viewing and Removing Mappings.
  3. For multiple data entities load type:

    A table is displayed showing the source data entities that are mapped to the target data entities. The number of mapped attributes between the two entities is also shown.

    The Number of mapped attributes is shown as n1/n2, where n1 is the number of mapped attributes in the source entity, and n2 is the total number of source attributes. For example, 5/10 means that the source entity has 10 attributes in total, and 5 attributes are mapped to attributes in the target.

    OptionDescription
    Filter by target data entity name or pattern

    Enter a name or pattern in the field and press Enter to filter the data entities list. You can enter a partial name or a pattern using special characters such as *. For example, enter c* to display only the entity names that begin with the letter C, such CUSTOMER_A and CUSTOMERS.
    Map by name

    By default, the option is not enabled because the Map by name mapping is already added. Data Integration automatically adds the default mapping, which maps source entity attributes to target entity attributes by their attribute names.

    The option is enabled when the Map by name mapping is removed.
    Add mapping

    Use the option to add more mappings, either manually or by using a pattern.

    See:
    View mappings (1)

    Use the option to view all the mappings that have been added to the data loader task. The number in parentheses shows the number of mappings.

    See Viewing and Removing Mappings.
Viewing and Removing Mappings

By default, Data Integration automatically maps source entity attributes to target entity attributes by matching attribute names. The default mapping is All attributes, of the type Map by name.

You can view the default mapping, and other mappings that you have added for mapping source entity attributes to target entity attributes.

  1. On the Create data loader task page, go to the Attribute mapping step.

    If the data loader task is configured for multiple entities load type, you might have to wait for the list of entities to display.

  2. Select View mappings (n).

    The number in parentheses shows the number of mappings. For example: View mappings (1)

    In the Mappings panel, the types of mappings are:

    TypeMapping
    Map by name

    All attributes

    Data Integration automatically adds the default mapping for mapping all attributes by attribute names.
    Map by pattern

    For example:

    *_NAME to $1_NAME might map the source attribute LAST_NAME to the target attribute TGT_LAST_NAME, and the source attribute FISRT_NAME to the target attribute TGT_FIRST_NAME.
    Manual

    For example:

    CITY to CITY_NAME maps the source attribute CITY to the target attribute CITY_NAME.
  3. To remove a mapping, you can use one of two ways:

    • Select the checkbox for a mapping, and then select Remove.

    • Select the Actions menu (Actions menu) for a mapping, and then select Remove.

Mapping an Attribute Manually

Create an attribute mapping manually by dragging a source attribute to a target attribute.

  1. On the Create data loader task page, go to the Attribute mapping step.

    If the data loader task is configured for multiple entities load type, you might have to wait for the list of entities to display.

  2. For single data entity load type:

    By default, all attributes are shown in the source entity and target entity tables. The menu above the Name column header indicates All. Attributes that aren't mapped don't have an icon in the Mapping column.

    1. In each table, select Attributes not mapped from the menu.
    2. To create a manual mapping, drag a source attribute to a target attribute.

      A Manual icon is added to the Mapping column.

  3. For multiple data entities load type:

    In the data entities table, the Number of mapped attributes column shows the number of source attributes that are mapped. For example, 5/10 means that the source entity has 10 attributes in total, and 5 attributes are already mapped to attributes in the target.

    1. Select the checkbox next to a source data entity, and select Add mapping.

      The Add mapping page displays, showing the attributes of the selected source entity in one table, and the attributes of the mapped target entity in another table. By default, all attributes are shown in both source and target entities. The menu above the Name column header indicates All.

      In both tables, an icon in the Mapping column indicates the type of attribute mapping. For example, Auto or Manual. You can place the cursor over a mapping to see the mapped attribute name. Attributes that aren't yet mapped don't have an icon in the Mapping column.

    2. In each table, select Attributes not mapped from the menu.
    3. To create a manual mapping, drag a source attribute to a target attribute.

      A Manual icon is added to the Mapping column.

    4. You can use the menu that's above the target attributes table to select another source entity and create more manual mappings.
    5. When you have finished creating manual mappings, select Save pattern mapping.
Adding a Mapping by Pattern (Single Entity Load)
  1. On the Create data loader task page, go to the Attribute mapping step.

    By default, all attributes are shown in the source entity and target entity tables. The menu above the Name column header indicates All.

  2. Select Add pattern.
  3. In the Map by pattern panel that appears, define a Source pattern and a Target pattern to map source attributes to target attributes. Pattern matching is case-sensitive.

    See Map by Pattern.

  4. Select Preview mapping to verify that the identified source attributes and target attributes are the attributes that you want to map.
  5. Edit the Source pattern and Target pattern, if needed, then select Preview mapping again.
  6. When done, select Map.
Adding a Mapping by Pattern (Multiple Entities Load)
  1. On the Create data loader task page, go to the Attribute mapping step.

    If the data loader task is configured for multiple entities load type, you might have to wait for the list of entities to display.

  2. Select the checkbox next to a source data entity, and select Add mapping.

    The Add mapping page displays, showing the attributes of the selected source entity in one table, and the attributes of the mapped target entity in another table. By default, all attributes are shown in both source and target entities. The menu above the Name column header indicates All. Attributes that aren't mapped don't have an icon in the Mapping column.

  3. In each table, you can select Attributes not mapped from the menu to list unmapped attributes only.
  4. Select Add pattern.
  5. In the Map by pattern panel that appears, define a Source pattern and a Target pattern to map source attributes to target attributes. Pattern matching is case-sensitive.

    See Map by Pattern.

  6. Select Preview mapping to verify that the identified source attributes and target attributes are the attributes that you want to map.
  7. Edit the Source pattern and Target pattern, if needed, then select Preview mapping again.
  8. When done, select Map.
  9. In the Add mapping page, above the target attributes table, select View all or use the menu to select another source entity. Then select Add pattern to create more mappings as described from step 5 through step 8.
  10. When you have finished creating mappings, select Save pattern mapping.