Saturday, December 7, 2013

OFSAA Rules - Introduction and Classification

Leave a Comment
The definition and maintenance of a transformation is achieved using Rules in OFSAA. The computation process is achieved by defining Rules.

Types of Rules:

In OFSAA Rules are primarily categorized into three categories:
1. Type 1 Rule
2. Type 2 Rule
3. Type 3 Rule

Type 1 Rule:

Table to Table Extracts (T2T’s) fall under Type 1 Rule category. T2T’s are basically mapping between tables defining the source columns and the target columns and their mapping. This type of Rule involves creation of subset of record on the basis of certain filters. This process may or may not involve transformations.

In OFSAA Type 1 Rules or T2T’s are created using Database Extracts located at:
Unified Metadata Manager/Data Integrator Framework/Warehouse Designer/Database Extracts

Type 2 Rule:

These types of Rules are known as the Re-classification Rules. Type 2 Rule involves re-classification of records in a table in the data model based on criteria that include sub queries within the tables. Type 2 Rule makes use of Hierarchy for both Source and Target and defines their mapping.

Type 3 Rule:

The most important Rule in OFSAA is Type 3 Rule, also known as the Computation Rule. Type 3 Rule involves computation of a new value based on measure and simultaneously updating the computed value in data model. Type 3 Rule has Hierarchy as a Source and Business Processor(BP’s) as Target and defines their mapping.

Both Type2 and Type3 Rules are created in OFSAA on the click of Designer in Rules Framework.


Post a Comment