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. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Assign a Parameter to the Target Data Object

Assign a Parameter to the Target Data Object

You can assign a parameter to a customized data object and change the source for the Write transformation at run time.
Parameterize the data object when you have a customized data object in the Model repository for more than one target data source. When you change the value of the parameter, the target changes for all objects that uses the parameter.
When you create a Write transformation from a customized data object, information about the data object appears on the
Data Object
tab of the transformation properties. You can click the data object name to view the definition from the Model repository. To parameterize the data object, create a resource type parameter or browse for a resource parameter. The parameter default value is the name of customized data object in the Model repository. When you create a default parameter value, you select a customized data object name from a list of data objects in the repository.
When you change the data object, the transformation ports change. You can view the ports on the
Ports
tab in the transformation properties.
The following table describes the parameter options on the
Data Object
tab:
Parameter Options
Description
Parameter
The name of a resource parameter that you configured as the data object. Read-only.
Description
The description of the parameter. Read-only.
New
Create a resource parameter. Browse for and select a data object in the Model repository for the parameter default value.
Browse
Browse for a resource parameter and select the parameter.
Default Value
The default value of the resource parameter that you configured for the data object. The default value is a customized data object name. Read-only.
Configure this functionality on the
Data Object
tab of the Write transformation for a relational target.

0 COMMENTS

We’d like to hear from you!