Data Quality Integration for PowerCenter Guide

10.5
- 10.5.4
- 10.4.1
- 10.4.0

Back Next

Data Quality Transformation Behavior in PowerCenter

When you import a data quality mapplet or mapping from the Model repository to the PowerCenter repository, the data quality transformation behavior can change.

Conversion to Mapplets

The following transformations can convert to mapplets on import to the PowerCenter repository:

Consolidation

Exception

Key Generator

Match

When you import a mapping that contains one or more of the transformations, PowerCenter converts each transformation to a mapplet that contains the expanded configuration.

When you import a mapplet that contains one or more of the transformations, PowerCenter expands the configuration of each transformation into multiple transformations.

PowerCenter might add transformations to the data quality transformation or mapplet expansion to complete the transformation logic. For example, PowerCenter expands the Match transformation with additional transformations.

Decision Transformation Considerations

You cannot export a mapping or a mapplet that contains a Decision transformation to PowerCenter if the transformation script includes a system parameter. The export operation cannot convert the system parameter to a value that PowerCenter can use. Before you export a mapping or a mapplet with a Decision transformation that uses a system parameter, replace the parameter with an appropriate value.

Match Transformation Considerations

You cannot run an identity match mapping in PowerCenter if the mapping reads or writes identity index data to database tables. To perform identity match analysis in PowerCenter, configure the Match transformation in the Developer tool to write identity index data to temporary files.

Multi-Strategy Transformations

You can define multiple data transformation strategies within each of the following transformations in the Developer tool:

Case

Classifier

Decision

Key Generator

Labeler

Match

Merge

Parser

Standardizer

When you import a mapplet or mapping that contains a multi-strategy transformation, each strategy converts to a separate transformation.

Rename Saved Search

Table of Contents

Data Quality Integration for PowerCenter Guide

Data Quality Integration for PowerCenter Guide

Data Quality Transformation Behavior in PowerCenter

Data Quality Transformation Behavior in PowerCenter

Conversion to Mapplets

Decision Transformation Considerations

Match Transformation Considerations

Multi-Strategy Transformations