Map

Set a Source Database Object

Before mapping, the Source database must be set for a Target Source (if it has not already been set). If the Field Mappings page displays SELECT SOURCE in the TARGET SOURCE DETAILS, then the Source database must be set.

NOTE: The Source Database Object is included in the Source Table and Source Rules name. It must be set before Source tables or rules can be built. Users can perform field mappings without a Source table for field mappings that use the Default, Internal and Not Used action.

NOTE: When a user sets the Source database Object and clicks Save, Map validates that the Source database Object exists in the System Type. If the Source database Object does not exist:

If the user imported a System Type in Target Design for the Target Source, the Source database Object is imported into the System Type

If the user did not import a System Type in Target Design (as in, an Excel file import, database table import, or manual entry was used for the Target design) Map displays an error message that the user must set a System Type before field mapping can be performed. Add a System Type to a Target in Target Design (Design > Targets >Vertical View for a Target > System Type ID).

To set the Source database 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 Vertical View for a Target Source.

  5. Click Edit.

    View the field descriptions for the Target Sources page's Vertical View

  6. Select a table or view from the Source Database Object list box.
  7. Click Save.