Country Dimension - Process M_V2O_COUNTRIES Specification

• Package: m_v2o_countries
  
• Description: Container for all procedures and functions relating to mapping data for the Countries Dimension from VAL to ODS.
• Procedure: map (Overload 1)
  
• Description: Wrapper to do mapping with housekeeping.
  
• Action:
• Run initialise mapping with parameters p_mapping = 'M_V2O_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 VAL.V_COUNTRIES to ODS.COUNTRIES.
  
• Parameters:
• p_run_no:
• Datatype: NUMBER
  
• Direction: IN
  
• Description: The run number for this run.
  
• Action:
• Insert into ODS.COUNTRIES any country in VAL.V_COUNTRIES that is not already there.
• Commit work.