Multi Queries in Talned DI

Four Stars

Multi Queries in Talned DI

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

 

Moderator

Re: Multi Queries in Talned DI

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: Multi Queries in Talned DI

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

 

 

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.