time dimension week,quarter start & end dates

Highlighted
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!
Highlighted
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.
Highlighted
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,
Highlighted
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....
Highlighted
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.
Highlighted
One Star

Re: time dimension week,quarter start & end dates

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog