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

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog