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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.