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