Terminologies

This section describes the terminologies used for data maps included in the document.

The Table Name indicates the name of the fact or the dimension in a star schema in the data warehouse.

Properties

The Properties table lists properties of the table independent of each field. The following properties are listed in the table:

Property	Value
Target Table	Name of the table in the target schema (data warehouse) into which data is loaded
Table Type	Fact or Dimension
SCD Type	Type 1: Existing records are updated directly. The nature of the dimension on how it handles changes made in the source system. Type 2: Existing records are inactivated by putting the current date as the effective end date and new records are inserted with an effective start date as today’s date. The new record will have the start date as the current date and a high date.
Fact Type	Whether this is a snapshot or transactional fact table Snapshot: Captures a snapshot view of the data as available in the source system during that period (monthly or weekly). Each snapshot's data is stored independently. Accumulation: Data from the source system is accumulated periodically. Changes from source system will be merged with the existing data. Multiple copies of the same data will not be maintained.
Source System Driver Table	Name of the table in source database from which data is extracted
Stage Table	Name of the table in the staging schema (data warehouse) that can be used to query the data records generated by the ETL logic
Oracle Data Integrator Package	Name of the ODI package that needs be executed to extract data from the source application and populate a specific target table in the data warehouse
ETL View	Name of the view in the data warehouse that has the logic for retrieval and transformation of the source data
Materialized View	Names of the materialized views delivered with the product for a specific fact table These materialized views are designed to support all of the OAS answers delivered with the product. Refreshing these materialized views will be taken care as part of the ETL processes.

Fields

The Fields table lists the individual properties of each field in the presentation table or the database table. The following fields are listed in those tables:

Property	Value
Source Field	Name of the field from the source application which is used to load the target field either directly or after transformation.
Target Field	Name of the column in the fact or dimension table present in the data warehouse. This is where the extracted data will be loaded into.
OAS Field	Name of the field in the OAS Presentation folder. If blank, the field is not available by default in OAS.