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

Steps to Create a Slowly Growing Target Mapping

Steps to Create a Slowly Growing Target Mapping

To create a slowly growing target mapping:
  1. In the Mapping Designer, click Mappings > Wizards > Getting Started.
  2. Enter a mapping name and select Slowly Growing Target, and click Next.
    The naming convention for mapping names is m_
    MappingName
    .
  3. Select a source definition to be used in the mapping.
    All available source definitions appear in the Select Source Table list. This list includes shortcuts, flat file, relational, and Application sources.
  4. Enter a name for the mapping target table. Click Next.
    The naming convention for target definitions is T_
    TARGET_NAME
    .
  5. Select the column or columns from the Target Table Fields list that you want the Integration Service to use to look up data in the target table. Click Add.
    The wizard adds selected columns to the Logical Key Fields list.
    The columns you select should be a key column in the source.
    When you run a workflow containing the session, the Integration Service performs a lookup on existing target data. The Integration Service returns target data when Logical Key Fields columns match corresponding target columns.
    To remove a column from Logical Key Fields, select the column and click Remove.
    You cannot add a port using the name, FILLER, to the Logical Key field list.
  6. Click Finish.
    The new mapping appears in the workspace. Make necessary edits to the mapping.
    The Fields to Compare for Changes field is disabled for the slowly growing target mapping.


Updated June 25, 2018