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