Map

Add Update Row Sources that are Tables

Create an Update Row Source table for use by pre-processing rules or to create a snapshot of data for result validation.

An Update Row Source can also be a view. Refer to Add Update Row Sources that are Views for more information.

The Update Row Source table is created using Map and SQL AutoGen. It then must be further configured in Transform.

To create an Update Row Source table in Map:

  1. Add an Update Row Source to an Add Row Source in Map by following the steps in Add Update Row Sources that are Views.

  2. Verify or add relationship joins if needed.

    NOTE: Relationship joins are required between Add Row and Update Row Source and are created automatically if the Add Row Source table has a primary key and the key also exists on the Update Row Source table. In this case, the left table in the join is the ST table of the Add Row Source and the right table is the Rule Source Table.
    If the Add Row Source does not have a primary key and/or the primary key columns on the Add Row Source do not exist on the Update Row Source database Object, the relationship setting the Rule Source Table to the ST Table for the Update Row Source is created, but the user must create the join manually. Refer to Add Relationship Joins to Sources for more information.

  3. After verifying or adding relationship joins, click Vertical View for the Update Row Source on the Target Sources (Update Row) page.

  4. Click Edit.

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

  5. Select Table in the ST Object Type list box.
  6. Click Save.
  7. Click the back arrow to return to the Target Sources (Update Row) page's Horizontal View.
  8. Click the Mappings icon for the Update Row Source.
  9. Select the field used in the relationship join and click Edit.
  10. Select Copy in the ACTION list box.
  11. Select the Source table in the Source TABLE field.
  12. Select the field name to copy the data to in the Source FIELD field.
  13. Click Save.
  14. Click Submit on the Page toolbar; Map creates the SQL Objects (depending on the Action selected) and sends a notification to the Developer assigned to the Target or Source to review the mapping on the Mapping Approval page. Refer to Approve or Reject Mappings for more information.

To create an Update Row Source table and rules In SQL Automation:

  1. Build Target Tables using SQL AutoGen
  2. Build Source Tables Using SQL AutoGen
  3. Build an Update Row Source Table Using SQL AutoGen
  4. Create Rules for an Update Row Source Using SQL AutoGen

In Transform, the Update Row Source table is registered with an Active status.

Review the Source priority on the Target Sources page in Transform to ensure the Update Row Source processes before the Add Row Source.