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

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!