Table of Contents

Search

  1. Preface
  2. Understanding Mapping Analyst for Excel
  3. Standard Mapping Specification Template
  4. Models Worksheet
  5. Packages Worksheet
  6. Domains and Enumerations Worksheets
  7. Mappings Worksheet
  8. Joins, Lookups, and Filters Worksheets
  9. Rules Worksheet
  10. Importing and Exporting Mapping Specifications

Mapping Analyst for Excel Guide

Mapping Analyst for Excel Guide

Rules Worksheet Overview

Rules Worksheet Overview

Use the Rules worksheet to define reusable rules that you can use as expressions on the Mappings worksheet. You can use rules in a mapping specification to perform simple data cleansing.
When you import a mapping specification that contains a rule defined on the Rules worksheet, the PowerCenter Repository Service creates a Java transformation for the rule. The mapping specification input parameters are the Java transformation input ports, the rule expression is the Java code, and the output results are the output ports.
If you export a PowerCenter mapping that includes a Java transformation, the PowerCenter Repository Service does not export the Java transformation to the mapping specification.
When you configure a rule, you can optionally use domains and enumerations defined on the Domains and Enumerations worksheets. When you specify a value for a parameter on the Rules worksheet, you can select from the list of possible reference values that are defined on the Enumerations worksheet.
The Rules worksheet is optional. If you do not configure rules, you can delete the worksheet type from the mapping specification.

0 COMMENTS

We’d like to hear from you!