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