Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Engineering Quality 10.5.9
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Rule Specifications
  3. Rule Specification Configuration
  4. Rule Set Configuration
  5. Rule Statement Configuration
  6. Common Types of Rule Statements
  7. Test and Validation Operations

Rule Specification Guide

Rule Specification Guide

Back Next

Conditions

Conditions

A condition is a data operation that a rule statement specifies for an input data value. Every rule statement contains at least one condition.
When a condition validates an input data value, the rule specification performs the action in the rule statement. If a condition cannot validate an input data value, the rule specification does not perform the action.
Configure a condition to perform one of the following types of analysis:
Compare the input data values to a single value.
The rule statement compares the values in the input column to the value that you enter.
Compare the input data values to the values on another input.
The rule statement compares the values in the input column to the values on the same row in another input column that you specify.
Compare the input data values to the current date and time.
The rule statement compares the values in the input column to the current date and time on the Data Integration Service host machine.
Search for null values.
The rule statement searches the input column for null or empty strings.
Compare the input data values to a range of values
The rule statement compares the values in the input column to a range of values that you enter.
Compare the input data values to the values in a reference table.
The rule statement compares the values in the input column to the values in a reference table. The rule statement returns a value from the reference table or a value that you enter.
Compare the input data values to the output from a mapplet.
The rule statement compares the values in the input column to the output from a mapplet that you select from the Model repository. You specify one or more inputs for the mapplet. You can select any input in the rule specification, including the current condition input. You can also specify a constant value as a mapplet input.
Apply a function expression to the input data values.
The rule statement applies a function expression that you select to the values in the input column. The Analyst tool stores the list of expressions.
0 COMMENTS
We’d like to hear from you!