time dimension week,quarter start & end dates

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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch