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

Step 1. Configure the Read_Customer_FF Read Transformation

Step 1. Configure the Read_Customer_FF Read Transformation

Configure the Read_Customer_FF Read transformation to use a parameter of type Resource to change the source data object between mapping runs.
  1. Add a Read transformation that represents the Customer_FF flat file data object.
    The Read transformation appears in the editor as Read_Customer_FF.
  2. In the
    Properties
    view, click the
    Data Object
    tab.
  3. Select
    Parameter
    in the
    Specify by
    list.
  4. Click
    New
    to create a new parameter.
    The
    Parameters
    dialog box appears.
  5. Enter the parameter name as
    Param_Src
    .
  6. Click
    Browse
    in the
    Default Value
    .
  7. In the
    Select location
    dialog box, select the data object that you want to provide as the default value.
    An example default value is
    MRS//Cust_Dept/Customer_FF
    , where
    MRS
    is the Model Repository Service and
    Cust_Dept
    is the project where the
    Customer_FF
    data object is stored. You can change the value of the parameter when you run the mapping.
The following image shows the
Data Object
tab after you define the settings:
The Data Object tab for the Read transformation specifies to use a parameter for the data object. Param_Src is the name of the parameter. The tab also shows the default value for the parameter. The tab contains an option to get data object columns from the data source at run time. The option is not selected.

0 COMMENTS

We’d like to hear from you!