topic Re: time dimension week,quarter start & end dates in Talend Studio

time dimension week,quarter start & end dates

anut — Thu, 15 May 2014 01:06:25 GMT

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!

Re: time dimension week,quarter start & end dates

Anonymous — Thu, 15 May 2014 15:18:01 GMT

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.

Re: time dimension week,quarter start & end dates

anut — Thu, 15 May 2014 17:13:03 GMT

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,

Re: time dimension week,quarter start & end dates

Anonymous — Thu, 15 May 2014 23:31:26 GMT

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....

Re: time dimension week,quarter start & end dates

anut — Fri, 16 May 2014 00:49:47 GMT

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.

Re: time dimension week,quarter start & end dates

_AnonymousUser — Mon, 27 Apr 2015 20:39:12 GMT

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