Introduction This Assignment, which is a Data Warehousing Design and Development assignment. Every Dimensional Model will have a Time Dimension. For this assignment you are required to design a Time Dimension, Write the code in PL/SQL that will populate the Time Dimension, and provide test plans for the code.
Design a Date Dimensions table Oracle SQL Developer Data Modeller Produce the DDL script using Oracle SQL Developer Data Modeller Run the DDL script in your Oracle schema. Design a PL/SQL program that will populate the Time Dimension table, with one record per day.
The PL/SQL program will accept 2 input parameters - Start Date and End Date
Use the PL/SQL program to populate the Time Dimension table for a range of dates. For example, use your PL./SQL program to populate your Time Dimension table using the following set of input parameters:
Input Parameters 1 : Start Date = 01/01/2005 End Date = 31/12/2020
Input Parameters 2 : Start Date = 01/01/2010 End Date = 14/02/2018
Input Parameters 3 : Start Date = 01/02/2015 End Date = 31/12/2025
HINT: Use the Date format mask of DD/YY/RRRR Your PL/SQL Program should have error checking. Assume all dates will be entered using the above format of DD/MM/YYYY
Your PL/SQL Program should be re-runable and should not require any manual intervention, apart from entering the dates.
YOU’LL NEED TO SUBMIT YOUR REPORT IN PDF
HINT: Keep it simple!