Four Stars

time dimension week,quarter start & end dates

Hi,
With the help of some posts on the forum, I was able to build a ETL for time dimension.
To populate week & quarter start and end dates, I used the talend componets like taggregate and tmap. I wanted to check if it can be done in any simpler way (using java code) than using multiple components in the ETL.
Thank You!
5 REPLIES
One Star

Re: time dimension week,quarter start & end dates

Did you consider a row generator solution like this:
http://diethardsteiner.blogspot.com/2012/02/talend-open-studio-populating-date.html
I prefer to use a procedural language rather than Talend for this work myself.
Four Stars

Re: time dimension week,quarter start & end dates

Thank you for the link. I am following the same solution but having a hard time to calculate week & quarter start and end dates using procedural language
Thanks,
Seventeen Stars

Re: time dimension week,quarter start & end dates

You do not have to do it for your self. Simply use the tCalendar component from Talend Exchange which does the job for you:
http://www.talendforge.org/exchange/index.php?eid=1126&product=tos&action=view&nav=1,1,1
Have a lot of fun....
Four Stars

Re: time dimension week,quarter start & end dates

Excellent! Thank you so much for the custom component. It has almost everything what I want in the time dimension table.
Looking at the schema description..I did not find a field which calculates Quarter start & end dates. Can these values also be calculated using this component. Also, can this component be used to populate data for a FY that starts on a different date (like April etc) then regular calendar.
Thanks in advance.
One Star

Re: time dimension week,quarter start & end dates

The link posted above for time dimension does not work for me.