Rules in Informatica Developer Overview
A rule is business logic that defines conditions applied to source data when you run a column profile. You can add a rule to the profile to validate data. You can use mapplets that are validated as rules, predefined rules, or reusable rules in the column profiles.
You can use the following methods to use rules in the column profiles:
- •In the Developer tool, create a mapplet and validate it as a rule. The rule appears as a reusable rule in the Analyst tool. You can apply the rule to column profiles in the Analyst tool and Developer tool.
- •You can use predefined rules in the column profiles. Informatica provides the predefined rules with the Developer tool and Analyst tool.
- •In the Analyst tool, create a rule specification and generate a mapplet. You can apply the rule specification to column profiles in the Analyst tool. In the Developer tool, validate the mapplet as a rule. The rule appears as a reusable rule that you can use in the column profiles.
Note: In the Developer tool, you cannot add, edit, or delete rule specifications in a column profile.
A rule must meet the following requirements:
- •It must contain an Input and Output transformation. You cannot use data sources in a rule.
- •It can contain Expression transformations, Lookup transformations, and passive data quality transformations. It cannot contain any other type of transformation. For example, a rule cannot contain a Match transformation as it is an active transformation.
- •It does not specify cardinality between input groups.