Map

Add Update Row Sources that are Views

If data must originate from a Source other than the Add Row Source table, add the Update Row Source and then specify the Update Row Source connection to the Add Row Source table using relationship joins.

An Update Row Source must have a relationship with an Add Row Source. Refer to Add Relationship Joins to Sources for more information.

NOTE: By default, an Update Row Source is added as a view. An Update Row Source can also be a table. Refer to Add Update Row Sources that are Tables for more information.

If the view doesn’t exist in the database, an Update Row Source view is autogenerated using the table name entered in the Source Database Object field on the Target Sources (Update Row) page. The view name is stored in the ST Table field on the Target Sources page’s Vertical View.

NOTE: An Add Row Source can have as many Update Row Sources as needed but an Update Row Source cannot have an Update Row Source.

NOTE: The actions available on the Field Mappings page are limited for an Update Row Source to:

  • Copy
  • Not Used
  • Rule
  • Manual Rule

No other options display in the ACTION list box when an Update Row Source is selected.

NOTE: When mapping an Update Row Source on the Field Mappings page, the Target Relationship ID on the Vertical View of the Field Mappings page for the Update Row Source is required.

To add an Update Row Source that is a view in Map:

  1. Click ProcessArea in the Navigation pane.
  2. Click the Targets icon on the Process Area Launch page.
  3. Click the Sources icon for a Target.
  4. Click the Update Row Sources icon for a Source.

  5. Click Add on the Target Sources (Update Row) page.

    View the field descriptions for the Target Sources (Update Row) page

  6. Select the Source from the Source ID list box.

    NOTE: These are Sources that have been added to the Target in Target Design.

  7. Select the Source table from the Source DATABASE OBJECT list box.
  8. Click Save.

NOTE: The ACTIVE check box is enabled by default. If unchecked, the Source cannot be used in a relationship and therefore cannot be used as an Update Row Source.

After the Update Row Source has been added in Map, review the Source priority on the Target Sources page in Transform to ensure Update Row Sources process before the Add Row Source.

In Transform, the Update Row Source view is registered with a Documentation status.