Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Step 2. Specify Mapping Details and Parameter Values

Step 2. Specify Mapping Details and Parameter Values

You can specify the parameter values for each mapping that you want to generate.
To specify the mapping details and the parameter values:
  1. In the first page of the Import Mapping Template Wizard, click the Add button.
  2. In the MappingName field, enter a mapping name.
  3. Optionally, enter a description.
  4. Click the Open button in the Parameters/Values field.
  5. Enter the following information in the Parameters for Mapping dialog box:
    Field
    Description
    Source Table
    All available source definitions of the current working directory.
    Incremental Extract Condition
    Incremental extract condition. For example, enter UPDATE-TS>SYSDATE-1 as incremental extract condition.
    Create Target Table
    Creates a target table instead of using an existing target table.
    The target database type will be the same as the source database type.
    Target Table
    All available target definitions of the repository folder.
    Surrogate Key
    Primary key of the target table.
    Logical Key Fields
    Columns of the source table that identify a particular entity.
    Comparison Key Fields
    Set of fields that identify a changed row between the source and target tables.
    The Database Types field shows the type of the database that you selected. You cannot modify this option.
  6. If you use an existing target table, set the field association. To set the field association, click Set Fields Association.
  7. In the Field Association dialog box, click the Add button.
  8. Select the source field from the Source Fields list.
  9. Select the target field from the Target Fields list.
  10. In the Field Association dialog box, click OK.
  11. In the Parameters for Mapping dialog box, click OK.
  12. In the Import Mapping Template Wizard, click Next.
    The second page of the Import Mapping Template Wizard displays the list of mappings you configured.


Updated June 25, 2018