Table of Contents

Search

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

Developer Mapping Guide

Developer Mapping Guide

Configure the Data Object to Use a Parameter

Configure the Data Object to Use a Parameter

Create a customerTrim_FF data object to add as the Write transformation in the mapping. Configure the data object to use a parameter of type String for the output file name.
  1. Create a
    customerTrim_FF
    data object based on the
    customerTrim.csv
    file.
  2. To use a parameter for the output file, perform the following steps:
    1. In the
      Parameters
      tab of the data object, click the
      New
      button ( "" 
					 ) to create a new parameter.
    2. In the
      Name
      column, change the parameter name as
      Param_TgtFile
      .
    3. In the
      Default Value
      column, click the
      Open
      button ( "" 
					 ).
      The
      Edit Parameter Value
      window appears.
    4. Enter the default file name value as
      customerTrim.csv
      and click
      OK
      .
  3. Save the
    customerTrim_FF
    data object.
The following image shows the
Parameter
tab with the new parameter:
The Parameters tab of the customerTrim_FF flat file data object lists the parameters in the data object. The tab shows the Param_TgtFile parameter.

0 COMMENTS

We’d like to hear from you!