Warehouse Libraries - Number Functions

Links to posts for this sub-system:

• Functional Specification
  
• Technical Specification
• Configuration Items
  
• Implementation Notes

Warehouse Libraries - Number Functions Implementation Notes

• Upload to CTL:
• lib_number.sql

• Run the following in order:
• CTL script: lib_number.sql
• CTL command: EXEC lib_util.create_grants;
  
• STA command: EXEC lib_util.create_synonyms;
• VAL command: EXEC lib_util.create_synonyms;
• ODS command: EXEC lib_util.create_synonyms;

• Run the test script; CTL: lib_number_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: lib_number_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_number_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_number_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.

Warehouse Libraries - Number Functions Configuration Items

This is a list of links to posts that comprise the configuration of the sub-system in the order that they must be implemented:

• Package LIB_NUMBER
  
• Test Script LIB_NUMBER_TEST
  

Warehouse Libraries - Package CTL.LIB_NUMBER Specification

• Package: lib_number
• Description: A set of library functions and procedures to support number manipulation.
• Function: cardinal_num
  
• Description: Return the cardinal string equivalent of the input number.
• Parameters:
• p_number:
• Datatype: NUMBER
  
• Direction: IN
  
• Description: The number.
• Return:
• Datatype: VARCHAR2
• Description: Cardinal.
  
• Action:
• Get the last digit
  
• Create a cardinal string based on the last digit.
• Return the cardinal string.
  

Warehouse Libraries - Number Functions 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:

• Processes
• LIB_NUMBER
  

Warehouse Libraries - Number Functions Functional Specification

This sub-system is a library collection of various procedures and functions that support number manipulation.