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 Source Data Object

Assign a Parameter to the Source Data Object

You can assign a parameter to the data object and change the source for the Read transformation at run time.
Parameterize the data object when you have a different physical data object in the Model repository for each data source. You might parameterize the data object if you need to configure the same transformation for a flat file or for a database table. When you parameterize the data object, you enable the transformation to use data objects that have different properties or unique SQL queries.
When you create a Read transformation from a physical 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 physical data object 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 physical data object in the Model repository. When you create a default parameter value, you select a physical 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 image shows the
Data Object
tab when you specify the data object by a parameter:
When you choose to specify by parameter, you can browse for an existing resource parameter or you can create a new resource parameter.
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 physical data object name. Read-only.
Configure this functionality on the
Data Object
tab of the Read transformation for a flat file or relational source.

0 COMMENTS

We’d like to hear from you!