Assumptions
This section lists all assumptions and default values for the Oracle Utilities Analytics Warehouse. These defaults are used in validation SQL queries and can be different based on user inputs, context code, and other factors. Make sure you replace these defaults with the appropriate values in your validation SQL queries.
Assumption | Meaning and Default Value |
---|---|
Release Administration Schema |
Name of the Oracle Utilities Analytics Warehouse Release administration schema. Default: RELADM |
Metadata Schema |
Name of the Oracle Utilities Analytics Warehouse Metadata schema. Default: MDADM |
Target Schema |
Name of the Oracle Utilities Analytics Warehouse Target schema. Default: DWADM |
ODI Work Repository |
ODI work repository schema name for Oracle Utilities Analytics Warehouse. Default: OUA_WORK |
ODI Master Repository |
ODI master repository schema name for Oracle Utilities Analytics Warehouse. Default: OUA_MASTER |
Context Code |
Terminology used by Oracle Data Integrator to uniquely identify a specific source database instance that is configured to load Oracle Utilities Analytics Warehouse. Examples of context codes used in Oracle Utilities Analytics Warehouse are CCB1, NMS1, or CCB2. Default: The default context code used in all validation SQL queries, of this checklist, is CCB1. If you are configuring a different source with a different instance number, replace CCB1 with the appropriate value in the validation SQL queries. |
Replication Schema |
Default: The default replication schema owner used in SQL queries is CCB1REP. Replication schema created by Oracle Utilities Analytics Warehouse with name as context_cd followed by REP. Replace CCB1REP with the appropriate schema name in validation SQL queries for different context. |
Database Link |
Default: The default DB link name used in SQL queries is CCB1_LINK. DB link created in metadata schema by Oracle Utilities Analytics Warehouse with name as context_cd followed by _LINK. Replace CCB1_LINK with the appropriate link name in validation SQL queries for different context. |
GoldenGate Owner in Source |
Default: The default GoldenGate owner used in SQL queries for source is CCB01SRC. If you are using a different user name, replace CCB01SRC with the appropriate name in validation SQL queries. |