I want to implement Calendar Dimension table using transformer. My requirement is to create load this table with all the dates from 2000 to 2015, day of week, month, quarter etc. I can easily get last three values using functions but how do I populate the table with all the dates in this 15 years of span. I don't want to write all of these manually. Is there anyway where in I can give start date and end date and get everything in between implemented?
If you want to spend less time on this, use excel to create the dates. Save it as .csv file and then use this file in your job to get the other values and load.