After successfully defining and creating the Source Mapping objects, you can generate the update procedure for each object via a template to populate the target table.
Generating update and custom procedures for Source Mapping objects is completed using the same workflow as all objects in RED that support template based procedure/script generation.
Executing a procedure associated with the Source Mapping object can be performed both interactively from the object's right-click context menu or via the Scheduler.

Note

  • Please ensure that you have created your own Source Mapping object templates, before performing the steps below.
  • You can also have an update or custom procedure defined on the target table, if a single consolidated procedure to process the table is required.
  1. Click the Rebuild button beside the Update Procedure drop-down in the Properties screen of the Source Mapping object, to launch the procedure generation Wizard.

    Note

    RED displays the name of the previously used update/custom procedure template below the Update Procedure and Custom Procedure drop-down fields by default.

  2. On the Processing tab of the Update Build Options screen, select the template to use from the Template drop-down or use the previous update procedure template. Configure the other options available as required. 
  3. Click OK to proceed with the procedure generation. The Results pane displays confirmation that the procedure was generated.
  4. Right-click the source table from the left pane and select Code > View update from the context menu to view the contents of the update procedure generated.
  5. Right-click the source table from the left pane and select Execute Update Procedure from the context menu to run the procedure. The Results pane displays the number of records created.

    Repeat the same steps described above to create update procedures for the other source mapping objects, defined for the target table. 

Bulk Update Procedure Regeneration

Once the update procedure code has been generated for the source mapping objects, RED enables you to perform bulk code regeneration in source mapping objects from multiple tables.
You can list all the source mapping objects in a Project, Project Group or Object Group and then perform bulk update via the right click context menu:

 
 
Refer to Listing Source Mapping Objects for details
 

  • No labels