I' m trying to find a solution. Is there a possibility to write multi queries in one module to teradata db? I have a big project in Talend DI with many modules and I want to consolidate it into one. I use 'TteradataInput' modules with 'TteradataConnection'.
Have you tried to
The query part of tTeradataInput can take query from the iteration. It looks like:(String)globalMap.get("row2.SqlQuery")
Thx for your answer. Anyways it complicates the project. I was looking for something simpler. I think there is no solution because I wonder one can't mix DDL and DML in one statement.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.