Browsing and Filtering the Source or Target Data Structure

The mapper displays the source data structure on the left and the target data structure on the right. You can filter the display of either structure.

To browse and filter the source or target data structure:
  1. To expand or collapse parent nodes one level at a time:
    1. Right-click the parent node and select Expand or Collapse.
    2. Click the Expand or Collapse icon to the left of the parent node.
  2. To expand or collapse nodes under a parent, right-click a row and select Expand or Collapse All Below.
  3. To promote a node to the top, right-click a row and select Show as Top. To return to the original view, select the Up arrow in the first row, then select the data structure hierarchy to access.

  4. To filter the source side, click Filter to specify map filtering options based on the following criteria, then click Apply. You can select one option from each section. When the Filter icon is displayed in blue, this indicates that the filter has been modified from its default settings and is active. To reset the filter option to its default values, click Reset All.
    • Current field status (show all fields, mapped fields, or unmapped fields (applies to target nodes to which a source, variable, or function has been mapped).

    • How fields are defined (all fields, required fields, or custom fields you created in a prebuilt Oracle integration that was edited in customization mode). You can select to filter both required and custom fields together.

    • The source data structures in the integration. This option is only displayed if there are multiple source data structures in this mapper. You can select to filter all data structures together.

    Description of mapper_source_filter.png follows
    Description of the illustration mapper_source_filter.png
  5. On the target side, click Filter to specify map filtering options based on the following criteria, then click Apply. You can select one option from each section. When the Filter icon is displayed in blue, this indicates that the filter has been modified from its default settings and is active. To reset the filter option to its default values, click Reset All
    • Current field status (show all fields or mapped fields (applies to target nodes to which a source, variable, or function has been mapped).

    • How fields are defined (all fields, required fields, or custom fields you created in a prebuilt Oracle integration that was edited in customization mode). You can select to filter both required and custom fields together.

    • The origin of mappings (all, standard, or custom).

    • Whether the mappings are valid. You can select to filter multiple options together.

    Description of mapper_target_filter.png follows
    Description of the illustration mapper_target_filter.png