Time Dimension - Configuration

Pre-Requisites:

Database Objects:

• p_time_lib - Time Library
• p_string_lib - String Library
• p_number_lib - Number Library
  

Script Sourced:

• tob_d_time:
• Type: Scalar Object Type
• Deployed to: whs@whs
• Support Scripts:
• Linux script library/whs/cre_tob_d_time.sql
• Linux script library/whs/dro_tob_d_time.sql
• tta_d_time:
• Type: Table Type
• Deployed to: whs@whs
• Support Scripts:
• Linux script library/whs/cre_tta_d_time.sql
• Linux script library/whs/dro_tta_d_time.sql
• Linux script library/whs/rec_tta_d_time.sql
• f_d_time:
• Type: Database Stored Function
• Deployed to: whs@whs
• Support Scripts:
• Linux script library/whs/f_d_time.sql

Designer Sourced:

• s_d_time:
• Type: Sequence
• Deployed to: whs@whs

OWB Sourced:

• Deployed to WHS_TGT
  
• Mappings:
• M_W2W_D_TIME
  
• Dimensions:
• D_TIME
• Connectors:
• WHS_CTL
• Deployed to OWF:
•