topic Re: Examples on how to load a date dimension and time dimension in a DW? in Talend Studio

Examples on how to load a date dimension and time dimension in a DW?

Anonymous — Sat, 16 Nov 2024 13:35:52 GMT

Hi there,
I'm a total Talend Open Studio newbee contemplating a switch from Pentaho's Kettle. We need a strong ETL tool to support our BI / data warehousing infrastructure (currently in the making).
As a first step in learning Talend Open Studio, I'm trying to load the date and time dimensions in my DW's star schema. Where can I find some example jobs to accomplish this?
Thank you very much,
Marcos

Re: Examples on how to load a date dimension and time dimension in a DW?

Anonymous — Fri, 22 Jan 2010 17:02:47 GMT

What is your source?
If you are just trying to have Talend generate the data for your dimension then you will have to know some Java and create a routine with methods that will generate the data for you. Java Doc
If you import the demo project there are a lot of examples in there. Go to the Open Studio project selection screen (the first window that opens up after you double-click the exe). Although there is nothing specific to "Loading a Date Dimension" you can find examples of most of the components.

Re: Examples on how to load a date dimension and time dimension in a DW?

_AnonymousUser — Mon, 26 Apr 2010 13:52:05 GMT

Please refer the following url for a sample time Dimension generator
http://www.talendforge.org/exchange/tos/extension_view.php?eid=288
Cheers,
Pravu