Skip Headers
Oracle® Communications Data Model Adapters and Analytics User's Guide
Release 11.3.2

E37699-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

6 NCC Adapter Reference

This chapter includes the following topics:

NCC Adapter Oracle Communications Data Model Target Tables

Table 6-1 shows the Oracle Communications Data Model target tables and the associated source tables for the NCC Adapter.

Table 6-1 Target Oracle Communications Data Model Tables for NCC Adapter

NCC Source Table Oracle Communications Data Model Target Table

BE_BALANCE

DWB_ACCT_BAL

BE_BUCKET

DWL_ACCT_TYP

BE_WALLET

DWL_UOM

CCS_AACT_ACCT_REFERENCE

DWR_ACCT

CCS_ACCT

DWR_AGRMNT

CCS_ACCT_REFERENCE

DWR_CUST

CCS_ACCT_TYPE

DWR_PROD_SBRP

CCS_BALANCE_TYPE

DWR_PROD_SPEC

CCS_BALANCE_UNIT

DWR_PRPD_VCHR

CCS_MB_RECHARGE

DWR_PRPD_VCHR_BTCH

CCS_RECHARGE_TYPE

DWR_PRPD_VCHR_RCHRG_OPTN

CCS_VOUCHER_BATCH

DWB_ACCT_PYMT

CCS_VOUCHER_REFERENCE

DWB_ACCT_PYMT_BAL_IMPC

CCS_VOUCHER_TYPE_VIEW

DWB_DATA_SRVE_EVT

CCS_WALLET_TYPE

DWB_WRLS_CALL_EVT

CCS_BE_CDR

DWD_SMS_EVT


NCC Adapter ODI NCC_OCDM Project

When you install and configure the NCC Adapter for Oracle Communications Data Model, an ODI project named NCC_OCDM project is defined. The NCC_OCDM project contains the following folders:

  • SRC_STG_NONAGG Folder contains packages used to populate the staging area with data from the NCC source system.

  • STG_OCDM Folder contains packages used to populate the foundation layer of an Oracle Communications Data Model warehouse with data from the NCC Adapter for Oracle Communications Data Model staging area.

SRC_STG_NONAGG Folder

The packages in the STG_STG_MPMAGG folder of the NCC_OCDM project populate the tables in the staging layer of the (that is, the tables defined in the ncc_stg database) from data in the NCC source system (that is, the tables defined in the NCC BE and CSS databases).

SRC_STG_LOAD_NON_OGG_PKG Package

This package loads data from the NCC source database into the NCC staging database. You use this package during an initial load and when you refresh the foundation layer using only ODI.

SRC_STG_EDR_LOAD_INCREMENTAL_PKG Package

This package loads the NCC source Event Detail Record incremental data into the Staging Database EDR Table (that is, the CCS_BE_CDR table).

SRC_STG_EDR_LOAD_INITIAL_PKG Package

This package loads NCC source Event Detail Record initial data into the Staging Database EDR Table (that is, CCS_BE_CDR). You use this package during an initial load of the foundation layer.

STG_OCDM Folder

The packages in the STG_OCDM folder populate the tables in the foundation layer of an Oracle Communications Data Model warehouse (that is, the tables defined in the ocdm_sys database) from data in the staging area (that is, the tables defined in the ncc_stg database).

The following packages are defined in the STG_OCDM folder of the NCC_OCDM project:

STG_OCDM_INITIAL_LOAD_PKG Package

This package loads data into the foundation layer tables of the Oracle Communications Data Model warehouse from data in the staging area delta tables (other than Event Detail Record objects). You use this package during the initial load and when refreshing the data using only ODI.This package executes interfaces in the STG_OCDM folder named ncc_source_table_MAP (where ncc_source_table is the name of an NCC source table listed in "NCC Source Schema Objects") in hierarchical sequence. These interfaces use the data in the staging delta tables (that is, the ncc_source_table_DELTA tables) to populate the related foundation layer tables.

The following interfaces are executed by this package:

  • BE_BALANCE_MAP

  • BE_BUCKET_MAP

  • CCS_ACCT_ BE_WALLET _MAP

  • CCS_ACCT_CNRT_MAP

  • CCS_ACCT_REFERENCE_MAP

  • CCS_ACCT_SBRP_MAP

  • CCS_ACCT_TYPE_MAP

  • CCS_BALANCE_TYPE_MAP

  • CCS_BALANCE_UNIT_MAP

  • CCS_MB_RECHARGE_MAP

  • CCS_RECHARGE_TYPE_MAP

  • CCS_VOUCHER_BATCH_MAP

  • CCS_VOUCHER_REFERENCE_MAP

  • CCS_WALLET_TYPE_MAP

STG_OCDM_EDR_PKG Package

This package loads tables in the foundation layer of an Oracle Communications Data Model warehouse from Event Detail Record objects in the staging layer. You use this package during the initial load and when refreshing the data using only ODI.

The package executes the following STG_OCDM Event Detail Record interfaces in hierarchical sequence:

  • EDR_FREEFROM

  • EDR_RECHARGE_BALANCE_TYPE

  • EDR_RECHRG

  • EDR_CALL_EVT

  • EDR_PREPAID

  • EDR_SMS

STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG Package

The STG_OCDM folder contains one package for each of the NCC source tables. These packages are named ncc_source_table_PKG where ncc_source_table is the name of an NCC source table listed in "NCC Source Schema Objects".

When these packages are in running mode, they execute the interfaces that populate the Oracle Communications Data Model foundation layer tables.

You use these packages when using Oracle GoldenGate to refresh the data in the staging layer.

STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG calls STG_OCDM_OGG_CDC_LOAD_PKG which finally calls the following interfaces:

  • BE_BALANCE_PKG

  • BE_BUCKET_PKG

  • CCS_ACCT_ BE_WALLET _PKG

  • CCS_ACCT_CNRT_PKG

  • CCS_ACCT_REFERENCE_PKG

  • CCS_ACCT_SBRP_PKG

  • CCS_ACCT_TYPE_PKG

  • CCS_BALANCE_TYPE_PKG

  • CCS_BALANCE_UNIT_PKG

  • CCS_MB_RECHARGE_PKG

  • CCS_RECHARGE_TYPE_PKG

  • CCS_VOUCHER_BATCH_PKG

  • CCS_VOUCHER_REFERENCE_PKG

  • CCS_WALLET_TYPE_PKG

ncc_stg Schema Objects

The ncc_stg schema defines the staging area used by the NCC Adapter for Oracle Communications Data Model. The schema contains the definitions outlined in Table 6-2.

Table 6-2 Definitions in the ncc_stg Schema

Object Type Object Name Description or Usage

Type

CDR_T

Supports the population of Event Detail Record (EDR) data.

Type

CDRSET_T

Supports for the population of EDR data.

Table

CCS_BE_CDR

Event detail record table.

Table

source_table_name

Normal staging tables. There is one table definition for each of NCC source tables listed in "NCC Source Schema Objects".

Table

source_table_name_LD

Previous day tables. There is one table definition for each of NCC source tables outlined in "NCC Source Schema Objects".

Table

source_table_name_DELTA

Delta tables. There is one table definition for each of NCC source tables outlined in "NCC Source Schema Objects".

Table

source_table_name_DELTA_H

Delta history tables. There is one table definition for each of NCC source tables outlined in "NCC Source Schema Objects".

View

CCS_RECHARGE_TYPE

This is a view in the staging area that corresponds to a view of the same name in the ncc_ccs database.

View

CDR_FREEFORM_RECHARGE

Supports the population of EDR data.

View

CDR_PREPAID

Supports the population of EDR data.

View

CDR_SMS

Supports the population of EDR data.

View

CDR_VOICE_CALL

Supports the population of EDR data.

View

VOUCHER_RECHARGE

Supports the population of EDR data.

View

VOUCHER_RECHARGE_BALANCE_TYPE

Supports the population of EDR data.

Package

EDR

Supports the population of EDR data.

Procedure

POST_STAGING_LOAD

Maintains the everyday source data changes and history of the data changes. Used by the Oracle GoldenGate option.

Procedure

PRE_STAGING_LOAD

Maintains the everyday source data changes and history of the data changes. Used by the Oracle GoldenGate option.

Procedure

PRE_OCDM_LOAD

Maintains the everyday source data changes and history of the data changes. Used by the ODI-only option.


NCC Source Schema Objects

The NCC Adapter for Oracle Communications Data Model uses the data in the following NCC tables as source data:

BE_BALANCE
BE_BUCKET
BE_WALLET
CCS_ACCT
CCS_ACCT_ACCT_REFERENCES
CCS_ACCT_REFERENCE
CCS_ACCT_TYPE
CCS_BALANCE_TYPE
CCS_BALANCE_UNIT
CCS_BE_CDR
CCS_MB_RECHARGE
CCS_VOUCHER_BATCH
CCS_VOUCHER_REFERENCE
CCS_WALLET_TYPE

Additionally, the NCC Adapter for Oracle Communications Data Model uses the CCS_RECHARGE_TYPE view as defined in the NCC css Database.

Schema Definitions Added by the NCC Adapter for Oracle Communications Data Model

Installing and configuring the NCC Adapter for Oracle Communications Data Model as described in Oracle Communications Data Model Installation Guide adds the following definitions:

  • A database named ncc_stg that defines a staging area for use by the adapter. For information on the definitions in this database, see "ncc_stg Schema Objects".

  • Procedure definitions that populate the foundation layer of an Oracle Communications Data Model warehouse. These definitions are added to the ocdm_sys schema delivered with Oracle Communications Data Model. For more information on these procedures, see "Definitions Added to the ocdm_sys Schema".

ncc_stg Schema Objects

The ncc_stg schema defines the staging area used by the NCC Adapter for Oracle Communications Data Model. The schema contains the definitions outlined in Table 6-3.

Table 6-3 Definitions in the ncc_stg Schema

Object Type Object Name Description or Usage

Type

CDR_T

Supports the population of Event Detail Record (EDR) data.

Type

CDRSET_T

Supports for the population of EDR data.

Table

CCS_BE_CDR

Event detail record table.

Table

source_table_name

Normal staging tables. There is one table definition for each of NCC source tables listed in "NCC Source Schema Objects".

Table

source_table_name_LD

Previous day tables. There is one table definition for each of NCC source tables outlined in "NCC Source Schema Objects".

Table

source_table_name_DELTA

Delta tables. There is one table definition for each of NCC source tables outlined in "NCC Source Schema Objects".

Table

source_table_name_DELTA_H

Delta history tables. There is one table definition for each of NCC source tables outlined in "NCC Source Schema Objects".

View

CCS_RECHARGE_TYPE

This is a view in the staging area that corresponds to a view of the same name in the ncc_ccs database.

View

CDR_FREEFORM_RECHARGE

Supports the population of EDR data.

View

CDR_PREPAID

Supports the population of EDR data.

View

CDR_SMS

Supports the population of EDR data.

View

CDR_VOICE_CALL

Supports the population of EDR data.

View

VOUCHER_RECHARGE

Supports the population of EDR data.

View

VOUCHER_RECHARGE_BALANCE_TYPE

Supports the population of EDR data.

Package

EDR

Supports the population of EDR data.

Procedure

POST_STAGING_LOAD

Maintains the everyday source data changes and history of the data changes. Used by the Oracle GoldenGate option.

Procedure

PRE_STAGING_LOAD

Maintains the everyday source data changes and history of the data changes. Used by the Oracle GoldenGate option.

Procedure

PRE_OCDM_LOAD

Maintains the everyday source data changes and history of the data changes. Used by the ODI-only option.


Definitions Added to the ocdm_sys Schema

Installing and configuring the adds the following procedure definitions to the ocdm_sys schema delivered with Oracle Communications Data Model.

DISB_CONS
ENAB_CONS
INSERT_REF
LOOK_UP_LOAD_ONE_TIME
UPDATE_ACCT
UPDATE_CHURN_DATE
UPDATE_CNRT
UPDATE_CUST
UPDATE_PROD
UPDATE_PRPD_VCHR_INSTNC
UPDATE_SBRP

The NCC Adapter for Oracle Communications Data Model uses these procedures as it populates the target objects.