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. |
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. |