Table of Contents
- Title and Copyright Information
- 1 About This Content
- 2 Introduction
-
3
Object Management
- 3.1 Boundaries and Limitations
- 3.2 Adding Dimension Tables and Key Dimension (Leaf) Registration
- 3.3 Adding Custom Instrument Tables
- 3.4 Adding Custom Transaction Tables
- 3.5 Adding Custom Lookup Tables
- 3.6 Adding Management Ledger Class tables
- 3.7 Object Registration and Validation
- 3.8 Alternate Rate Output Columns
- 3.9 User Defined Properties
- 3.10 Modifying the Precision of Balance Columns In Ledger Stat
- 4 Utilities
-
5
Data Loaders
-
5.1
Dimension Loaders
- 5.1.1 Enhancements to Support Alphanumeric Code in Dimensions
- 5.1.2 Tables that are Part Of Staging
- 5.1.3 Populating STG_<DIMENSION>_HIER_INTF Table
- 5.1.4 Dimension Load Procedure
- 5.1.5 Setting up Dimension Loader
- 5.1.6 Executing the Dimension Load Procedure
- 5.1.7 Exception Messages
- 5.1.8 Updating DIM_<DIMENSION>_B <Dimension>_Code column with values from DIM_<DIMENSION>_ATTR table
- 5.1.9 Truncate Stage Tables
- 5.2 Simple Dimension Loader
- 5.3 Historical Rates Data Loader
- 5.4 Forecast Rate Data Loader
- 5.5 Prepayment Rate Data Loader
- 5.6 Stage Instrument Table Loader
- 5.7 Customer T2T Loading
- 5.8 DIM_Party Population
- 5.9 Instrument Summary Table
- 5.10 Transaction Summary Table Loader
-
5.11
Ledger Data Loader
- 5.11.1 Features and Limitations of the Load Procedure
-
5.11.2
Setup for the LEDGER_STAT load utility
- 5.11.2.1 FSI_DATA_IDENTITY insert/update during Ledger_load
- 5.11.2.2 Creating View on LEDGER_STAT table
- 5.11.2.3 Creating Load Table
- 5.11.2.4 Creating Unique Index on Load Table
- 5.11.2.5 Creating Views on Load Table
- 5.11.2.6 Setting up Global Temporary Table
- 5.11.2.7 Tables Related to LEDGER_STAT Load Procedure
- 5.11.2.8 Populating Stage Tables
- 5.11.2.9 Executing LEDGER_STAT Load Procedure
- 5.11.2.10 CALENDAR_MONTHS
- 5.11.2.11 FISCAL_ONE_MONTH
- 5.11.2.12 FISCAL_RANGE
- 5.11.2.13 Executing LEDGER_STAT Load Procedure for MULTI CURRENCIES
- 5.11.3 Exception Messages
- 5.11.4 Tables Cleanup After Truncation Of Ledger_Stat
- 5.12 Cash Flow Loader
- 5.13 Pricing Management Transfer Rate Population
- 5.14 ALMBI Transformation
- 5.15 Hierarchy Transformation
- 5.16 Dim Dates Population
- 5.17 Fact Ledger Stat Transformation
- 5.18 Financial Element Dimension Population
- 5.19 Payment Pattern Loader
- 5.20 GAP Limits Loader
- 5.21 Material Currency Identifier
- 5.22 Behaviour Pattern Loader
-
5.1
Dimension Loaders
- 6 SCD Process