11.2 About the External Engine

Oracle provides Interface Tables to source the External Engine Outputs as POI (Processing Output Integration) Tables and related Metadata (T2Ts) to handle all the ETL Activities and load the data into the Application-specific Result Tables in OFSDF. As a result, the need of rebuilding of OFSAA specific complex Data Transformation logics, constant maintenances, and data anomalies during currency conversions are eliminated.

POI Tables form the Input Layer, using which the customer can source the data.

As a part of the External Engine, the following provisions are made:

· A separate POI Subject Area is created to hold all the POI Tables.

· POI Table Names are prefixed with POI_.

· T2Ts are provided to load the Application-specific Result Tables from corresponding POI Tables. These T2Ts are loaded as Common Metadata.

· The FSDF_EXCHNG_RATE Sub Process is introduced in the EXTERNAL ENGINE RUN.

NOTE

The External Engine T2Ts are not a part of the default PMF in OFSDF. Customers can include them as required.

The structure of these POI Tables is similar to that of the Application-specific Fact Tables, however, in the place of Surrogate Key, the POI Tables contain the Business Key. The following similar changes are made:

· All the Flag, Indicator, Amount, Rate, Percentage, Date, Code, and ID Columns are a part of the POI Table and these Columns are loaded as-is from the POI Tables to the Fact Tables.

· The Code Columns are provided in the POI tables corresponding to the Fact Table Surrogate Keys.

· Base Amount Columns corresponding to the RCY (Reporting Currency) and LCY (Local Currency) Columns of the Fact Table are added to the POI Table. Currency Conversion is a part of the T2T based on the populated Exchange Rates. Currency Code Column is added to the POI Table.

· POI Table granularity is same as that of the Application-specific Fact Tables along with the FIC_MIS_DATE and LOAD_RUN_ID.