User Guide

10.2.2
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.1

Back Next

Rules in a Streaming Mapping

A rule expresses the business logic that defines conditions applied to source data. You can add expression rules to streaming mapping to cleanse, change, or validate data. Create expression rules in the Analyst tool.

You might want to use a rule in different circumstances. You can add a rule to cleanse one or more data columns.

Rules that you create in the Analyst tool appear as mapplets in the Developer tool. You can use a mapplet in a mapping or validate the mapplet as a rule.

In a streaming mapping, you can use the following functions in expression rules:

LastDay

Add to Date

Concat

Date Diff

Date Time

Greatest

Choose

Least

Length

Null

Reverse

Truncate

Convert to Data

For more information about rules, see the

Informatica Profile Guide

For more information about mapplets, see the

Informatica Mapping Guide

Streaming Mappings

Rename Saved Search

Table of Contents

User Guide

User Guide

Rules in a Streaming Mapping

Rules in a Streaming Mapping