Data Quality Integration for PowerCenter Guide

Data Quality Integration for PowerCenter Guide

Data Quality Transformation Behavior in PowerCenter

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.

0 COMMENTS

We’d like to hear from you!