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