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

Defining Write Transformation Ports

Defining Write Transformation Ports

Define target object columns by mapping flow to enable upstream mapping objects to update the incoming ports for the Write transformation.
  1. In the
    Properties
    view, click the
    Ports
    tab.
  2. Select
    Columns defined by: Mapping flow
    .
    The following image shows the
    Ports
    tab populated with ports defined by the associated data object:
    To define columns by mapping flow, select the Mapping Flow option in the Ports tab.
  3. Enable dynamic ports and targets:
    1. Drag upstream ports to the
      input
      pane of the Write transformation.
      The target gets column definitions from upstream mapping objects.
    2. In the
      Properties
      view, click the
      Advanced
      tab.
    3. Select
      Create or replace table at run time
      in the
      Target Schema Strategy
      list.
      The following image shows the
      Target Schema Strategy
      option in the
      Advanced
      tab of the target object:
      To configure a Write transformation to create or replace the target table at run time, select the option in the Advanced tab.
      At run-time, the Data Integration Service retains, or drops and replaces, the target table.
      When a mapping contains multiple targets whose columns are defined by the same physical data object, select the
      CREATE - Create or replace table at run time
      target schema strategy option for only one of the targets. If you select the option for more than one target, the metadata of the table that the mapping creates would match only one of the targets, and the mapping fails.

0 COMMENTS

We’d like to hear from you!