Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Create Target Columns from the Mapping Flow

Create Target Columns from the Mapping Flow

Add the Write transformation to the mapping and configure the Write_customerTrim_FF transformation to create target files at run time based on the columns from the Exp_Output transformation.
  1. Add the customerTrim_FF data object as the Write transformation to the mapping.
  2. In the
    Properties
    view of the Write transformation, click the
    Ports
    tab.
  3. Choose the
    Mapping flow
    option to define the columns for the target.
    The Developer tool creates a dynamic port
    input
    in the Write_customerTrim_FF transformation.
    The following image shows the
    Ports
    tab after you choose the option:
    The Ports tab in the Properties view of the Write transformation shows the options that you can choose to define the target columns and also shows the new dynamic port input.
    The following image shows the new dynamic port
    input
    in the Write_customerTrim_FF transformation:
    The Write transformation contains the new dynamic port input.
  4. From the Exp_Output transformation, drag the All Ports group to the
    input
    port in the Write_customerTrim_FF transformation.
    The Developer tool creates a link and flows the columns from the All Ports group of the Exp_Output transformation to the input dynamic port of the Write transformation.
    The following image shows the
    m_Replication_Template
    mapping with the Write transformation configured:
    The mapping contains a Read transformation, two Expression transformations, and a Write transformation. The Exp_TRIM transformation has a dynamic port that is linked from the All Ports group in the Read transformation and another dynamic output port. The Exp_Output transformation has a dynamic port that is linked from the All Ports group in the Read transformation and another dynamic port linked from the Exp_TRIM transformation. The Write transformation has a dynamic port that defines the target columns based on the columns of the Exp_Output transformation.

0 COMMENTS

We’d like to hear from you!