4 Direct Loads

Direct Load enables you to Fast Load the tables into the Oracle Database.

For more information on Direct Load, see the Oracle Financial Services Analytical Applications Infrastructure User Guide.

The following tables must be loaded using the Direct Load Method before the Run Charts are executed:

Table 4-1 Direct Load Tables

Table Name	Description
FSI_M_USER	Stores all the users who are not Relationship Managers but are Business Users who have access to data at different levels. The User ID in this table should match the User's Login ID of OBIEE.
FSI_M_USER_MANAGER_MAP	Stores all the users who are Relationship Managers. V_User_name should hold the Obiee Login ID of the user who is a Relationship Manager. The Manager Code Column should match with the entry in dim_management.
DIM_REGION	A gergraphical region to which the customer belongs.
FCT_REG_CAP_ACCOUNT_SUMMARY	Stores the regulatorty capital related information from the BASEL Applications.This table must be loaded after loading the DIM Tables.