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_INV_SNPST |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWA_CDSHR_BRDG |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CHKIN_DLY |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWA_CUST_SRVEY |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWA_DLY_BKG |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWA_DLY_CALL_CNTR_PRFMNCE |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWA_DLY_FLT_DTLS |
FLT_DT_KEY |
DAY |
TBS_MV |
|
DWA_DLY_LYALTY_ACCT |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWA_DLY_LYALTY_ACCT_BKG |
CLNDR_KEY |
DAY |
TBS_MV |
|
DWB_ACCT_LVL_HIST |
VALID_DT |
DAY |
TBS_BASE |
|
DWB_ACCT_PYMT |
PYMT_DT |
DAY |
TBS_BASE |
|
DWB_ACCT_TRNSFR |
TRNSFR_DT |
DAY |
TBS_BASE |
|
DWB_BKG_AGNT_OPT_LN |
OPT_DT |
DAY |
TBS_BASE |
|
DWB_BKG_CMPGN_ASGN |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_RMRK |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_SSR |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_SSR_BRDG |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_STAT_CHNG_HIST |
STAT_CHNG_DT_TIME |
DAY |
TBS_BASE |
|
DWB_BKG_TST_FARE_DATA |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_TST_PFC_TAX_AMT |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_TST_PRC |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_TST_SEG |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWB_BKG_TST_TAX |
SRC_SYS_CRTD_TMSTMP |
DAY |
TBS_BASE |
|
DWD_BKG_FCT |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_CALL_CNTR_PRFMNC |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_CHKIN |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_SRVY |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_FLT_DTLS |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_LYLTY_ACCT_BAL_HIST |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_LYLTY_ACCT_LVL_HIST |
CLNDR_KEY |
DAY |
TBS_DERIVED |
|
DWD_RVN_CST_DRVD |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_TCKT |
CLNDR_KEY |
DAY |
TBS_DERIVED |