topic Multi Queries in Talned DI in Talend Studio

Multi Queries in Talned DI

Anonymous — Fri, 11 Jan 2019 16:09:05 GMT

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

Re: Multi Queries in Talned DI

Anonymous — Mon, 14 Jan 2019 07:33:11 GMT

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

Re: Multi Queries in Talned DI

Anonymous — Thu, 17 Jan 2019 10:44:35 GMT

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