Country Dimension - Process M_O2W_COUNTRIES Specification

• Package: m_o2w_countries
• Description: Container for all procedures and functions relating to mapping data for the Countries Dimension from ODS to WHS.
• Procedure: map (Overload 1)
  
• Description: Wrapper to do mapping with housekeeping.
  
• Parameters: None.
  
• Action:
• Run initialise mapping with parameters p_mapping = 'M_O2W_COUNTRIES', run_no = local variable to capture the run number.
• Run map (overload 2) with parameter p_run_no = the captured run number.
• Run finalise mapping with parameter run_no = the captured run number.
  
• Procedure: map (Overload 2)
  
• Description: Map ODS.COUNTRIES to WHS.D_COUNTRIES.
  
• Parameters:
• p_run_no:
• Datatype: NUMBER
  
• Direction: IN
  
• Description: Run number of this map run.
  
• Action:
• Insert into ODS.COUNTRIES any country in VAL.V_COUNTRIES that is not already there.
• Update and rows in D_COUNTRIES that differ in detail from COUNTRIES.
• Commit work.