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.6
  • 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

Function Configuration in Conditions

Function Configuration in Conditions

You can configure the data operation in a condition as a function expression. You can also select a function expression from a list of expressions in the rule specification. Use the function options in the condition to configure or select the expression.
You can use the function options as an alternative to the inline condition options that the rule statement displays in the workspace. You can also use the function options to configure a condition that reads multiple inputs or that reads an asset from the Model repository.
Use the
Define Condition
 dialog box to configure or select a function expression. To open the dialog box, select
function
 as the condition type in the rule statement.
The following image shows the
Define Condition
 dialog box:
The Define Condition dialog box options define the comparison operation for the condition. Select an option type on the left-hand side of the dialog box. Use the editable fields to define the comparison operation.
The dialog box contains the following options:
  1. Input
    Use the Input options to compare an input data value to other data values in the following ways:
    • Compare the rule statement input with an input from another column on the same row.
    • Compare the rule statement input with a value that you enter.
    • Compare the rule statement input with a range of values that you enter.
  2. Rules
    Use the Rules options to compare an input data value to the output from a mapplet. Use the options to select the mapplet from the Model repository. The Library workspace identifies the mapplets that you can select as rules.
  3. Reference Table
    Use the Reference Table options to compare an input data value with the values in a reference table. Use the options to select the reference table from the Model repository. The Library workspace lists the reference tables that you can select.
  4. Search
    Use the Search options to find an input data value in another input column. The rule statement searches all of the values in the column for the current rule statement input value.
  5. Function
    Use the Function options to apply a function expression to the input data. Select an expression from the list in the dialog box.
  6. Configurable options for the operation
    Use the options to configure the condition.
0 COMMENTS
We’d like to hear from you!