Multi Queries in Talned DI

[Anonymous]

Hello,

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

Regards,

Simon_123

[Anonymous]

Hello,

Have you tried to input the entire query from file to tTeradataInput? For example,

tFileInputXXX--->row1(main)--->tFlowTolerate--->iterate-->tTeradataInput

The query part of tTeradataInput can take query from the iteration. It looks like:(String)globalMap.get("row2.SqlQuery")

Best regards

Sabrina

[Anonymous]

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.

Best regards

Simon