Table of Contents


  1. Preface
  2. Introduction to Data Engineering Streaming
  3. Data Engineering Streaming Administration
  4. Sources in a Streaming Mapping
  5. Targets in a Streaming Mapping
  6. Streaming Mappings
  7. Transformation in Streaming Mappings
  8. Window Transformation
  9. Appendix A: Connections
  10. Appendix B: Monitoring REST API Reference
  11. Appendix C: 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
Developer Mapping Guide


We’d like to hear from you!