4 Managing Data

This chapter explains how your raw business data can be loaded into the Oracle Financial Crimes Data Model (FCDM) in various ways.

The following approaches are available either through the OFSDF Common Staging Area Model (CSA) or converting the raw data into Data Interface Specification (DIS) flat files.

This chapter focuses on the following topics:

• About Data Management
• Data Loading and Processing Flow Overview
• Managing Data Loading
• Managing Data Processing
• Managing Data For BD Applications

About Data Management

Data Management consists of Data Processing. Data loaded into the FSDM is processed for data derivation and data aggregation using the BDF processing datamaps. The processing refers to the wide range of activities to include data enrichment and data transformation.

Data Loading and Processing Flow Overview

In BD applications, data is loaded into the FSDM from the following data sources:

• BD Flat File Interface
• Common Staging Area (CSA) in FSDF

Data stored in the FCDM is then processed using BD processing datamaps where additional data derivations and aggregations are stored in the FCDM.

• CSA: The CSA provides a single repository for data storage for multiple functional areas and applications having the Common Staging Area Model and Reporting Data Model. The Common Staging Area Model provides a simplified, unified data sourcing area for inputs required by FCCM using BD.
• Flat Files: The flat files contain data provided by the client. This data is loaded into the Financial Crimes Data Model (FCDM).
• FCDM: The FCDM is a database which consists of well organized business data for analysis. It determines the structured data which stores persistent information in a relational database and is specified in a data modeling language.
• BD Datamaps: The BD datamaps load Business, Market and Reference data required for alert processing. It does the data derivation and aggregation after the BD Ingestion Manager loads the base tables.