Country Dimension - Technical Specification

A number of objects will be built to support this sub-system. Objects are normally located in specific schemas depending on their role:

• CTL: Control information.
• STA: Staged (raw) data.
• VAL: Validated (in terms of datatypes, column widths, etc.) data.
• ODS: Operational Data Store.
• WHS: The data warehouse.
  

CTL:

• Data
• HTML_PAGES
• MAPPING_LIBRARIES

STA:

• Tables:
• S_COUNTRIES
  
• Processes
• M_S2S_COUNTRIES
• M_S2V_COUNTRIES
  

VAL:

• Tables
• V_COUNTRIES
• Processes
• M_V2O_COUNTRIES

ODS:

• Tables
• COUNTRIES
• Processes
• M_O2W_COUNTRIES

WHS:

• Sequences
• D_COUNTRY_S
  
• Tables
• D_COUNTRY