Every Datawarehouse maintains a time dimension. It would be at the most granular level at which the business runs at (ex: week day day of the month and so on). Depending on the data loads these time dimensions are updated. Weekly process gets updated every week and monthly process every month.
Generally we load the Time dimension by using SourceStage as a Seq File and we use one passive stage in that transformer stage we will manually write functions as Month and Year Functions to load the time dimensions but for the lower level i.e. Day also we have one function to implement loading of Time Dimension.
create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg the code below fills up till 2015. You can modify the code to suit the feilds in ur table.
