Table of Contents

Search

  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. Window Transformation
  8. Appendix A: Connections
  9. Appendix B: Monitoring REST API Reference
  10. 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
.