Function F_D_TIME

Introduction:

A function to support the M_W2W_D_TIME mapping. This, pipelined, function creates a row for the dimension D_TIME for each date that falls into the period specified by the input parameters and returns the values in a table type; tta_d_time.

Location:

WHS@WHS

Sourced From:

dwmgr - $DW_WHS/f_d_time.sql



Deployed To:

WHS@WHS

API:

FUNCTION f_d_time(
   p_start_date      IN VARCHAR2,
   p_end_date        IN VARCHAR2)
RETURN tta_d_time;

Notes:

• Specification.