3.4 Fact Data Flow

Most of the Fact tables are mapped to staging counterparts through Table to Table (T2T) mappings. Data from source systems can be loaded into staging through flat file or source system interfaces. T2T process then loads data to fact tables. Examples include Fact Common Account Summary, Fact CRM Account Summary, and so on.

Some of the Fact tables are loaded with processed fact information from other fact tables. Examples include Fact CRM Customer Summary, and so on.

Table 3-2 FACT Table Flow

Fact Entity Name	Source	Source Entities	Method of populating measures
Fact Common Account	Summary	Stage Stage Annuity Contracts Stage Bill Contracts Stage Borrowings Stage Cards Stage CASA Accounts Stage Guarantees Stage Investments Stage LC Contracts Stage Leases Contracts Stage Loan Contracts Stage Money Market Contracts Stage Over Draft Accounts Stage Term Deposit Contracts Stage Trusts	T2T
Fact CRM Account Summary	Stage	Stage Commitment Contracts Stage Mutual Funds Stage Annuity Contracts Stage Bill Contracts Stage Borrowings Stage Cards Stage CASA Accounts Stage Guarantees Stage Investments Stage LC Contracts Stage Leases Contracts Stage Loan Contracts Stage Money Market Contracts Stage Over Draft Accounts	T2T
Fact Common Customer Summary	Stage	Stage Commitment Contracts Stage Mutual Funds Stage Customer Details Stage Party Rating Details Stage Party Financials	T2T
Fact CRM Customer Summary	Stage and Fact	Stage Customer Master Stage Customer Details Fact Common Account Summary Fact Transaction Channel	T2T/DT
Fact Application	Stage	Stage Applications	T2T
Transaction Channel	Stage	Stage Internet Transactions Stage Branch Transactions Stage ATM Transactions Stage Telebanking Transaction Stage Point Of Sale Transactions	T2T
Fact Cards Balance Summary	Stage	Stage Credit Card Balance Summary	T2T
Fact Account Feature Map	Stage	Stage Account Feature Map	T2T
Fact Customer to Customer Relationship	Stage	Stage Customer to Customer Relationships	T2T
Fact Account Profitability	Fact	Fact Common Account Summary Fact FTP Account Summary Fact PFT Account Summary	DT
Exchange Rate History	Stage	Stage Exchange Rates	T2T
Fact Account Segment Score	Fact	Fact Common Account Summary	T2T
Fact Account Segment MOB Summary	Fact	Fact Account, Fact Profitability, Fact Common Account Summary, Fact Account Segment Score	DT
Fact Party Account Role Map	Stage	Stage Party Account Role Map	T2T
Fact Party Financials	Stage	Stage Party Financials	T2T

This table will be populated in presence of the RCA application with the T2T. In absence of RCA, this table has to be directly loaded if the data is available.

The OFSRPA uses some materialized views registered as Derived Entity, that must be refreshed as and when the dependent table has fresh data. The MVs can be refreshed by running the batches crated for the purpose. The list of Derived Entity and the dependent objects can be found in the following table.

Table 3-3 Derived Entities and Dependent Objects

MATERIALIZED_VIEW	REFERENCED_NAME	REFERENCED_OBJECT_NAME
ACNTSMRM	FCT_COMMON_ACCOUNT_SUMMARY	Table
	FCT_CRM_ACCOUNT_SUMMARY	Table
CUSTDETM	DIM_CUSTOMER	Table
	DIM_CUSTOMER_TYPE	Table
	DIM_GENDER	Table
	FCT_COMMON_CUSTOME R_SUMMARY	Table
FCSTCUSR	VW_ACCT_VAL_FCST_CUSTAGG_RPA	Table
FCSTLTMR	VW_FORECAST_LTV_RPA	Table
FCSTREPR	VW_ACCT_VAL_FCST_REP AGG_RPA	Table
FSIUSRD	FSI_USER_DATA_ACCESS	Table
MGMTPFTM	ACNTSMRM	Table
	CUSTDETM	Table
	FCT_ACCOUNT_MGR_REL	Table
	FCT_ACCOUNT_PROFITABILITY	Table
MVRACPRO	A_DIM_REP_CURRENCY	Table
	DIM_ACCOUNT	Table
	DIM_CONSOLIDATION	Table
	DIM_CURRENCY	Table
	DIM_CUSTOMER	Table
	DIM_CUSTOMER_TYPE	Table
	DIM_DATES	Table
	DIM_LOB	Table
	DIM_ORG_UNIT	Table
	DIM_PRODUCT	Table
	DIM_REP_LINE	Table
	DIM_VINTAGE	Table
	FCT_ACCOUNT_PROFITABILITY	Table
	FCT_COMMON_CUSTOMER_SUMMARY	Table
	FCT_CRM_ACCOUNT_SUMMARY	Table
	MVUSRACC	Table
MVRCUSAG	A_DIM_REP_CURRENCY	Table
	DIM_ACCOUNT	Table
	DIM_CONSOLIDATION	Table
	DIM_CURRENCY	Table
	DIM_CUSTOMER	Table
	DIM_CUSTOMER_TYPE	Table
	DIM_DATES	Table
	DIM_LOB	Table
	DIM_ORG_UNIT	Table
	DIM_PRODUCT	Table
	DIM_REP_LINE	Table
	DIM_VINTAGE	Table
	FCT_ACCOUNT_PROFITABILITY	Table
	FCT_COMMON_CUSTOMER_SUMMARY	Table
	FCT_CRM_ACCOUNT_SUMMARY	Table
	MVUSRACC	Table
MVRPROAG	A_DIM_REP_CURRENCY	Table
	DIM_ACCOUNT	Table
	DIM_CONSOLIDATION	Table
	DIM_CURRENCY	Table
	DIM_CUSTOMER	Table
	DIM_CUSTOMER_TYPE	Table
	DIM_DATES	Table
	DIM_LOB	Table
	DIM_ORG_UNIT	Table
	DIM_PRODUCT	Table
	DIM_REP_LINE	Table
	DIM_VINTAGE	Table
	FCT_ACCOUNT_PROFITABILITY	Table
	FCT_COMMON_CUSTOMER_SUMMARY	Table
	MVUSRACC	Table
MVUSRACC	DIM_ACCOUNT	Table
	FCT_COMMON_ACCOUNT_SUMMARY	Table
	FSIUSRD	Table
RTHREPMV	WITH_REP_LINE_DIRECT_IND_RPA	Table
USRMGRMV	FSI_M_USER_MANAGER_MAP	Table