Table of Contents


  1. Preface
  2. Introduction to Big Data Streaming
  3. Big Data Streaming Administration
  4. Sources in a Streaming Mapping
  5. Targets in a Streaming Mapping
  6. Streaming Mappings
  7. Window Transformation
  8. Connections
  9. Sample Files

Rules in a Streaming Mapping

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


We’d like to hear from you!