DataFlux Data Management Studio 2.6: User Guide
A business rule is a reusable object that specifies a DataFlux expression that filters table rows. For example, a rule might check for rows in which the value of Profits per Employee is less than Assets. Events can be triggered based on the results that are returned by the rule. A business rule can be used in one or more profiles or data jobs.
This topic describes how to use the Execute Business Rule node to apply a business rule to rows of data as they flow through a data job. This node bypasses the need to associate business rules to tasks and associate events to triggered rows.
Before you can use this node:
The following example job is used for illustration:
The goal of this job is to identify all records in the Company Numeric table where the profits per employee are less than the assets. The first node is a Data Source node that specifies a DSN connection to the Company Numeric table. It also specifies the fields that will be evaluated by the rule. The second node is an Execute Business Rule node that specifies a business rule that will identify all records in the Company Numeric table where the profits per employee are less than the assets.
It is assumed that you know how to create and run data jobs.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfDMStd_Task_Execute_BusRule.html |