Warehouse Libraries - Utilities Implementation Notes

• Upload to CTL:
• lib_util_a.sql
• lib_util_h.sql
• lib_util_b.sql
  

• Upload to STA:
• lib_util_a.sql
• lib_util_h.sql
• lib_util_b.sql
  

• Upload to VAL:
• lib_util_a.sql
• lib_util_h.sql
• lib_util_b.sql

• Upload to ODS:
• lib_util_a.sql
• lib_util_h.sql
• lib_util_b.sql
  

• Run the following in order:
• CTL script : lib_util_a.sql
• STA script : lib_util_a.sql
• VAL script : lib_util_a.sql
• ODS script : lib_util_a.sql

• The test script is not designed to be run under CTL.
  
• Run the test script; STA: lib_util_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: lib_util_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: lib_util_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.