topic Re: Time Dimension Generator in Talend Studio

Time Dimension Generator

Anonymous — Sat, 16 Nov 2024 13:27:16 GMT

A Sample Talend job for generating Time Dimension is kept at the following location.
http://www.talendforge.org/exchange/tos/extension_view.php?eid=288
A datamart or data warehouse usually need a time dimension to use for date queries that look at periods, weeks, months, etc. There are multiple different ways to generate rows in Time Dimension table and here is one of those ways and by using Talend 3.1.
This Sample ETL Job creates and inserts data into the Time Dimension table .
For more details please read the document provided in the ZIP file.
Thanks,
Pravu.

Re: Time Dimension Generator

Anonymous — Sun, 25 Apr 2010 16:15:57 GMT

Hello Pravu
Cool! , thanks for your sharing!
Best regards
Shong

Re: Time Dimension Generator

Anonymous — Wed, 23 May 2012 21:40:13 GMT

Hi,
Does anybody know, how to set dinamically the parameters, start date and end date, in the tTimerGeneration component? For example:
1. I retrieve the start and end dates from a config table in my database.
2. I need to execute tTimerGeneration with the start and end dates retrieved int the step one.
Thanks.
Carlos.

Re: Time Dimension Generator

_AnonymousUser — Sat, 02 Feb 2013 01:26:23 GMT

Hi Pavu,
Thanks for sharing. I'm a novice to Talend. I'm interested in your example. I downloaded your zip file and tried. I got error "If this component has output, there must be an input link to propagate the data". I looked for your document and readme files in the zip but didn't find them. I only saw the pictures of your example (same as the example job when I loaded) in the images/job_outlines folder in the zip. Is it possible if you can send them to me so I can try to debug what I'm missing?
Thank you very much in advance,
Anh

Re: Time Dimension Generator

Anonymous — Tue, 30 Jul 2013 11:53:52 GMT

Don't worry about the error, just hit continue .. it'll still populate the table.
Thanks for the graph, its great!
Regards,
Adrian

Re: Time Dimension Generator

Anonymous — Thu, 09 Jan 2014 10:10:30 GMT

Hi folks,
is there a Generator available for Talend 5.4? I Don't understand why this is not a standard componante at all since this is a important feature for setting up DWHs and very time consuming doing it on your own?!
Regards

Re: Time Dimension Generator

janhess — Thu, 09 Jan 2014 10:33:45 GMT

Just use this one. But I'd redo the join between tJava and tJavaRow to get rid of the error.

Re: Time Dimension Generator

Anonymous — Thu, 09 Jan 2014 14:31:05 GMT

Just use this one. But I'd redo the join between tJava and tJavaRow to get rid of the error.

For some reason I couldn't open this one so I build my own one after this guide: http://www.robvonk.com/talend/time-dimension/
Feel free to use it: https://www.dropbox.com/s/fckpoftqmng3srx/DateTimeDimensionGenerator.zip

Re: Time Dimension Generator

janhess — Thu, 09 Jan 2014 14:33:43 GMT

I just imported it into 5.4.1 ok.

Re: Time Dimension Generator

Anonymous — Thu, 09 Jan 2014 15:02:48 GMT

We usually create those data in a spreadsheet file because there are mostly user specific extentions like different company holidays and so on. This table can easily imported via a simple talend job.
Mostly we do that once or twice per livetime of the data ware house.