Map the fields for migration

  1. On the Mapping section, specify this information:
    Source
    Select a source field from the list.

    The list contains the fields selected on the Source tab of the migration task.

    Destination
    Select a destination field from the list.

    The list contains the fields selected on the Destination tab of the migration task.

    QuerySql
    Specify a query statement.

    The query statement is used to retrieve a field from the database that is passed on to the destination field. You can use query statements when retrieving a foreign key value that is not available on the current workspace but is available on the database.

    See Set the destination dependencies.

    You can use this format for query statements:

    SELECT fieldname FROM tablename WHERE condition field = source parameter
    Note: Source parameter is a field from the source table or object with the prefix @, such as @color_code.

    For example, For example SELECT COLORRNG FROM FSH1. COLORRNG WHERE COLORRNGCODE = @color_code.

  2. Click Save.