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

Override Properties

Override Properties

When you import, the import process preserves the override, by default. You can choose to preserve or ignore the override properties of PowerCenter objects during the import process.
In PowerCenter, you can override some of the mapping properties. To override the properties, configure the properties for the session on the Mapping tab in the Workflow Manager.
With session overrides, you can override properties, such as Source File Name with different values in different sessions in PowerCenter. For example, you can set the
Source File Name
property with a value of 'OriginalFile'. Session 1 can override the value as "Session1_File" and Session 2 can override the value with "Session2_File".
When a PowerCenter mapping contains session overrides, the import process internally converts the session overrides by defining mapping or data object parameters in the Model repository and binds it to the parameter at the mapping task.
If you want to preserve the override properties in a Model repository, consider the following information:
  • The import process creates reusable and nonreusable transformations or reusable data objects for the PowerCenter objects.
  • If a PowerCenter mapping overrides source and target properties, the import process creates a data object with the same override property values as the PowerCenter mapping. The import process appends a number to the name of the PowerCenter object and creates the data object.
  • You can only preserve some override properties for the flat file sources, flat file targets, Lookup transformation, relational sources, and relational targets.
The following table lists the preserved override properties of PowerCenter objects in a Model repository:
PowerCenter Client Property
Developer Tool Property
Owner Name
. Find in the relational source session properties.
Owner
. Find in the mapping instance run-time properties.
Source Table Name
. Find in the relational source session properties.
Resource
. Find in the mapping instance run-time resource properties.
Reject file directory
. Find in the relational target session properties.
Reject file directory
. Find in the mapping instance run-time properties.
Reject filename
. Find in the relational target session properties.
Reject file name
. Find in the mapping instance run-time properties.
Target Table Name
. Find in the relational target session properties.
Target Table Name
. Find in the mapping instance run-time resource properties.
Pre SQL
. Find in the relational source or target session properties.
Pre SQL
. Find in the mapping instance advanced properties.
Post SQL
. Find in the relational source or target session properties.
Post SQL
. Find in the mapping instance advanced properties.
Sql Query
. Find in the relational source or target session properties.
SQL Query
. Find in the mapping instance query properties.
User Defined Join
. Find in the source qualifier properties.
Join
. Find in the mapping instance simple query properties.
Source Filter
. Find in the source qualifier properties.
Filter
. Find in the mapping instance simple query properties.
Lookup SQL override
. Find in the relational Lookup transformation session properties.
Lookup SQL override
. Find in the lookup query properties.
Lookup table name
. Find in the relational Lookup transformation session properties.
Resource
. Find in the lookup advanced run-time resource properties.
Lookup source filter
. Find in the relational Lookup transformation session properties.
Filter Query
. Find in the lookup query simple filter properties.
Lookup cache directory name
. Find in the flat file or relational Lookup transformation session properties.
Lookup cache directory name
. Find in the lookup run-time properties. For example, CacheDir (param).
Lookup source file name
. Find in the flat file Lookup transformation session properties.
Lookup source file name
. Find in the lookup data object specify by parameter properties.
Lookup source file directory
. Find in the flat file Lookup transformation session properties.
Lookup source file directory
. Find in the lookup data object specify by parameter properties.
Lookup column delimiter
. Find in the flat file Lookup transformation session properties.
Delimiters
. Find in the lookup data object advanced column delimiter properties.
Source File Directory
. Find in the flat file source session properties.
Source file directory
. Find in the data object advanced read properties.
Source Filename
. Find in the flat file source session properties.
Source file name
. Find in the data object advanced read properties.
Column Delimiter
. Find in the flat file source session properties.
Delimiters
. Find in the data object advanced column delimiters properties.
Reject filename
. Find in the flat file target session properties.
Reject file name
. Find in the mapping instance run-time properties.
Column Delimiter
. Find in the flat file target session properties.
Delimiters
. Find in the data object advanced column delimiters properties.
Merge File Directory
. Find in the flat file target session properties.
Merge file directory
. Find in the data object advanced write properties.
Merge File Name
. Find in the flat file target session properties.
Merge file name
. Find in the data object advanced write properties.
Output file directory
. Find in the flat file target session properties.
Output file directory
. Find in the data object advanced write properties.
Output filename
. Find in the flat file target session properties.
Output file name
. Find in the data object advanced write properties.
Reject file directory
. Find in the flat file target session properties.
Reject file directory
. Find in the mapping instance run-time properties.


0 COMMENTS

We’d like to hear from you!