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