Transform

Assign Additional Target Sources

A Target Source is a record of the relationship between a Source table and a Target table. Build rules against a Target Source to process specific Source tables for specific Target tables. This allows multiple Sources to be registered to a single Target and processed individually.

Transform contains the Target Sources created in Target Design. A Target Source is a database containing the Source data. Its name begins with sdb. Additional Source tables can be assigned to a Target.

Refer to Manage Target Sources for more information about working with Target Sources, including adding Target Source rules and Target Source reports.

NOTE: Syniti follows a strict naming convention for creating names that each member of the object can understand. Any manually created objects must also follow these conventions. Refer to Naming Conventions for more information.

To add Target Sources to a Target in Transform:

  1. Click the Targets icon on the Process Area Launch page.
  2. Click the Sources icon for a Target.
  3. Click Add on the Target Sources page in the child pane.

    View the field descriptions for the Target Sources page.

  4. Enter a value in the PRIORITY field.

    NOTE: If multiple Sources are registered to the Target, the priority is the order the Target Source is processed.

  5. Update the STATUS list box if the default value of Inactive is not applicable.
  6. Select a Source from the SOURCE ID list box.

    NOTE: SOURCE ID is the user friendly name for the Source database. This database is assigned to the Source in Target Design, and always begins with sdb.

  7. Update the SOURCE DATABASE OBJECT list box if the default value is not applicable.

    NOTE: SOURCE CONNECTION TYPE is the Source table from the Source database.

  8. Select a type from SOURCE CONNECTION TYPE list box.

    NOTE: Refer to Data Source Connection Types for detailed information.

  9. Click Save; the Vertical View displays.

    NOTE: The CONNECTION TYPE selected on the Horizontal View determines which fields display on the General tab and the Process Information tab in Vertical View. Refer to the following table for more information.

     

    Field

     

    Description

    Source Connection Type

    Database

    Local File

    None

    Protected Package

    General tab

    Package Name

     

    CranPort or SSIS import package

    X

    X

     

    X

    Source Path

    Location of the Source directory

     

    X

     

     

    Truncate Before Import

    A check box to specify if a Source table is truncated before an import package is run against it.

    X

    X

     

    X

    Process Information tab

    Create Import Table 

    Automatically generates the import table.

    X

    X

     

    X

    View Import Table

    Displays details of the imported Source table.

    X

    X

     

    X

  10. Populate all applicable fields.
  11. Click Save.