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

One Star

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

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
Employee

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

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

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

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