Working with ETL and finding a new tool to implement a code that is already implemented in another tool is a nice work. I am trying to explore the Open Source Tool (Talend Open Studio (TOS)) and yes if I find this Open Source Tool equally powerful as a Licensed tool then it means a lot of savings in the License costs. The preliminary research was obviously on the internet, cosolidating views and posts from different websites and blogs.
After doing some research on thy open source nature of TOS, I explored the tool at the component level. Now I am trying to write my first piece of code, an I am stuck. For me this TOS is not very intuitive in understanding (not like Abiniti ETL). Given a proper classroom training this tool can be easy but learning it on the net with the help of documents posted on the Talend Forum may take time. Not sure though. I have just started.
I have been working with Abinitio ETL earlier and now I have moved to Talend Open Studio. I am new to talend ETL. I am trying to implement a simple logic for which if anyone has a clue please help me. It was pretty simple with Abinitio Tool but I am finding it dificult with Talend ETL.
The Problem:
1. I have a table RUNDT which has Runkey, Date and a runflag as attribute. This is extracted using Stored Procedures in MSSQL.
2. If the runflag is "Y" then I have to run the following process:
2(a): Extract Project_ID from Project_Master table. Project_master tables has number of projects. Means it has multiple records.
2(b) Now for each project_id, I have to perform the following steps
i) Read another Table Resource_table
ii) Along with project_id plus attributes from Resource_table I have to load it into a staging table.
I have implemented the same logic in SSIS but I am finding it difficult to use the tforeach iteration in Talend Open Source.
The snapshot of the SSIS application:
All help appreciated!!
I have posted the same questions in Talend Community Forum
No comments:
Post a Comment