Calendar Dimension

agpt · Post by **agpt** » Tue May 25, 2010 10:37 am

Hi All,

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?

priyadarshikunal · Post by **priyadarshikunal** » Tue May 25, 2010 10:42 am

Why not to use row generator and then keep adding dates in downstream transformer?

agpt · Post by **agpt** » Tue May 25, 2010 11:01 am

can u pls be more specific?

chulett · Post by **chulett** » Tue May 25, 2010 12:09 pm

Check the documentation for the Row Generator stage, specifically the types of data it can generate.

vinothkumar · Post by **vinothkumar** » Tue May 25, 2010 12:15 pm

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.

agpt · Post by **agpt** » Tue May 25, 2010 12:17 pm

Thanks Craig.... I got it....

Vinoth, I didn't want to write 15 years equivalent dates so.... anywez got the solution now. Thanks.