This chapter provides the partitioning strategy for the Oracle Airlines Data Model physical base, derived, and aggregate tables.
This chapter includes the following section:
Table 5-1 shows the partitioning strategy for the Oracle Airlines Data Model physical base, derived, and aggregate tables.
Table 5-1 Physical Data Model Partitioning
| Physical Table Name | Partition Key Column | Partition Level | Default Tablespace Name |
|---|---|---|---|
|
DWA_BKG_DLY_INVT_SNPST |
BKG_DT_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_CHKIN_DLY_FACT |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_CUST_SRVY |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_BKG_FACT |
BKG_DT_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_CALL_CNTR_PRFMNC |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_FLT_DETLS |
FLT_DT_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_LYLTY_ACCT |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_LYLTY_ACCT_BKG |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWB_ACCT_LVL_HIST |
VLD_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_XFER |
XFER_DT |
MONTH |
TBS_BASE |
|
DWB_BKG |
BKG_CREN_DTTM |
MONTH |
TBS_BASE |
|
DWB_CHKIN |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_CMNSTRY_ERNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_CMPL_ADVC |
ACPT_DT |
MONTH |
TBS_BASE |
|
DWB_CMPL_ADVC_H |
ACPT_DT |
MONTH |
TBS_BASE |
|
DWB_DIRCT_ERNG |
FLT_DT |
MONTH |
TBS_BASE |
|
DWB_ERNG_EVNT |
ERNG_EVNT_DT_TM |
MONTH |
TBS_BASE |
|
DWB_FLT_CHNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_FLT_CHNG_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_FLT_SCHD |
FLT_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_ACCT_BAL_HIST |
BAL_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_ACCT_LVL_HIST |
VLD_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_CONV |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_LYLTY_PNTS_EXPR_H |
EXPIRE_EVNT_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_PRG |
LYLTY_PRG_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_PDI |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PNR |
PNR_CRE_DTTM |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN |
INTRATN_EVNT_DT_AND_TM |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_CALL |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_CALL_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_EML |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_EML_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_FAX |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_FAX_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_H |
INTRATN_EVNT_DT_AND_TM |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_ITEM |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_ITEM_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_LETR |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_LETR_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_SMS |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_THRD |
INTRATN_THREAD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_THRD_H |
INTRATN_THREAD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_VISIT |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_VISIT_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PTNR_ERNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_SEG_SCHD |
SCHD_SEG_ARVL_DT_TM_LCL |
MONTH |
TBS_BASE |
|
DWB_SEG_SCHD_H |
SCHD_SEG_ARVL_DT_TM_LCL |
MONTH |
TBS_BASE |
|
DWB_TKT |
TKT_ISNG_DT |
MONTH |
TBS_BASE |
|
DWB_XFER_ERNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWD_BKG_FACT |
OPRTNG_SEG_DEPTR_LCL_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_CALL_CNTR_PRFMNC |
INTRATN_EVNT_DTTM_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_CHKIN_FACT |
CLNDR_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_CUST_SRVY |
INTRATN_THREAD_STRT_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_FLT_DETLS_FACT |
ARVL_LCL_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_LYLTY_ACCT_BAL_HIST |
CREATE_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_LYLTY_ACCT_LVL_HIST |
VLD_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_LYLTY_PRG |
LYLTY_PRG_STRT_DT |
MONTH |
TBS_DERIVED |
|
DWD_PNR |
PNR_CRE_DTTM |
MONTH |
TBS_DERIVED |
|
DWD_TKT |
DT_OF_ISS |
MONTH |
TBS_DERIVED |