I made my first steps with talend this week and like it very well! The last years I did all my reporting stuff by using OLTP databases. I just updated an "analyzing-database" every night and then I got my business answers with sql code. Now I wanna level up by using OLAP with its star schema. I know how it's work, but I really don't know WHEN I have to made the changes from classical relational structure to multidimensional structure. I've loaded different kind of sources and mixed it on a tMap Element. Technically everything works fine, but stupidly mixing/joining tables seems not to be the solution :-)
Thank you for ya help.
Do you want to transfer data from your OLTP db to OLAP db? Talend supports ETL from input source to output source.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema