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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog