Download User Manual: Product Name

User Guide: Oracle Financial Services Basel Regulatory Capital IRB Approach User Guide,
Release 6.0.0.0.0
2.
Specify the properties by entering the required value or selecting an option from the drop down
list.
3.
Click
icon and save the details.
Post Load Transformation
Transformation refers to a rule describing the conversion of source data from source to the destination.
During the data extraction, a transformation rule facilitates in structuring the required data from sources to
the target or an intermediate systems for further processing. Based on the selected mode, transformations
can be applied to execute the process successfully. For example, an SQL rule with the “SELECT”
statement can retrieve source data from specific table(s). Post Load Transformation within the Data
Integrator framework of Infrastructure system facilitates you to define transformations to the source data
before extracting/loading it to Target database to populate the data warehouse.
The Post Load Transformation Designer screen displays the list of pre-defined Transformations in the LHS
menu and the Transformation Process Flow to help you navigate and define Post Load Transformations.
The Post Load Transformation Designer screen facilitates you to create, update, and delete the following
transformations:

Insert/Update Transformation

Stored Procedure Transformation

External Library
Insert/Update Transformation
Insert/Update Transformation facilitates you to define transformation parameters, create expression with
source, destination, and join/filter conditions, add transformation logic, and query the SQL Rule generated.
To Insert or Update Transformation in the in the Post Load Transformation Designer screen:
1.
Click
icon in the Transformation Process Flow tool bar.
2.
In the Post Load Transformation Definition grid.
o
Enter the Transformation Name. Ensure that there are no special characters or extra
spaces in the name specified.
o
Enter a Description for the transformation.
o
Click Next and save the details. You are automatically navigated to the Insert
Oracle Financial Software Services Confidential-Restricted
22