D.1 CSA Datamaps

This topic lists the files which can be run using FSDF Staging.

Files have been grouped in such a way that files in the same group can be executed in parallel to load data. However, you must execute Group 1 through Group 6 in sequence.

Note:

You must run the Country and Customer data files before you run the other files in their respective Groups.

Table D-1 CSA Datamaps Grouped

Group	Logical Table Name
1	Country
2	Account Phone Watch List Account Email Address Insurance Product Insurance Policy Insurance Transaction Insurance Policy Balance Front Office Transaction Account Customer Role Organization Insurance Policy Feature Insurance Policy To Customer Market Index Daily Loan Issuer Loan Daily Activity Market Index Online Account Service Team Insurance Seller Service Team Member Insurance Seller To License Customer Credit Rating Customer Identification Document
3	Account To Peer Group Account Group Peer Group Security Firm Daily Market Index Member Security Security Customer
4	Account Watch List Entry Loan Product Employee Front Office Transaction Party Organization Relationship Restriction List
5	Managed Account Account To Customer Account Group Member Account To Correspondent Account Balance Account Address Customer To Markets Served Customer To Products Offered Customer To Customer Relationship Anticipatory Profile Customer Phone Customer Email Address Customer Country Customer Address Online Account To Account Controlling Customer Employee To Account Account Position Security Trading Restriction Employee Trading Restriction Employee Phone Employee Email Address Employee Address Security Group Member Security Investment Rating Structured Deal Account Profit And Loss Account Investment Objective Account Position Pair Mutual Fund Breakpoint Market News Event
6	Borrower Account Restriction Back Office Transaction Investment Advisor Settlement Instruction Loan Origination Document Print Log

Group Dependencies

Processing data in Group1 requires no prerequisite information (dependencies) for Pre-processing. Groups 2-5, however, rely on successful pre-processing of the previous group to satisfy any dependencies. For example, the Ingestion Manager does not run Group 4 until processing of data in Group 3 completes successfully.

Processing bases the dependencies that determine grouping on the referential relationships within the data. If the Oracle client chooses not to perform referential integrity checking, grouping is not required (except in some instances). In this case, a need still exists to process some reference data files prior to processing trading data.