Country Dimension - Implementation Notes

• Upload to CTL:
• country_dimension_ctl_d.sql
  

• Upload to STA:
• s_countries_a.sql
• s_countries_t.sql
• s_countries_i.sql
• s_countries_c.sql
• m_s2s_countries_a.sql
• m_s2s_countries_h.sql
• m_s2s_countries_b.sql
• m_s2v_countries_a.sql
• m_s2v_countries_h.sql
• m_s2v_countries_b.sql
  

• Upload to VAL:
• v_countries_a.sql
• v_countries_t.sql
• v_countries_i.sql
• v_countries_c.sql
• m_v2o_countries_a.sql
• m_v2o_countries_h.sql
• m_v2o_countries_b.sql

• Upload to ODS:
• o_countries_a.sql
• o_countries_t.sql
• o_countries_i.sql
• o_countries_c.sql
• m_o2w_countries_a.sql
• m_o2w_countries_h.sql
• m_o2w_countries_b.sql
  

• Upload to WHS:
• d_countries_a.sql
• d_countries_t.sql
• d_countries_i.sql
• d_countries_c.sql
• d_countries_s.sql

• Run the following in order:
• CTL script: country_dimension_ctl_d.sql
• STA script: s_countries_a.sql
• STA script: m_s2s_countries_a.sql
• VAL script: v_countries_a.sql
• VAL command: EXEC lib_util.create_grants;
• STA command: EXEC lib_util.create_synonyms;
• STA script: m_s2v_countries_a.sql
• ODS script: o_countries_a.sql
• ODS command: EXEC lib_util.create_grants;
• VAL command: EXEC lib_util.create_synonyms;
• VAL script: m_v2o_countries_a.sql
• WHS script: d_country_a.sql
• WHS script: d_country_s.sql
• WHS command: EXEC lib_util.create_grants;
• VAL command: EXEC lib_util.create_grants;
• ODS command: EXEC lib_util.create_synonyms;
• ODS script: m_o2w_countries_a.sql
• STA command: EXEC lib_util.create_grants;
• VAL command: EXEC lib_util.create_synonyms;
• ODS command: EXEC lib_util.create_synonyms;

• Run the test script; STA: m_s2s_countries_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; STA: m_s2v_countries_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; VAL: m_v2o_countries_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; ODS: m_o2w_countries_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.