5.16 Dim Dates Population

DIM_DATES_POPULATION is a seeded Data Transformation which is installed as part of the OFSAA BI applications installers. Time dimension population transformation is used to populate the dim_dates table with values between two dates specified by the user.

Note:

During data transformation, the data will be loaded into FISCAL columns by reading the start date/end date information from DIM_FINANCIAL_YEAR table. Users can enter data manually into DIM_FINANCIAL_YEAR table.