SQL query on tMap output

One Star

SQL query on tMap output

If i have a job like this:
tOracleInput_1 --> main -->
tMap
tOracleInput_2 --> lookUp -->
in tMap i do an INNER JOIN with tables and in the tMap Editor i defined an output called OUT. Now i need to do an SQL query (f.e. a SELECT) in OUT. How can i do? What kind of component i need to connect to the output of tMap?I can't create another table on Database, i can use OUT as a table?How?
Thanks.
One Star

Re: SQL query on tMap output

Hi,
doing a SELECT for you output OUT means fetching additional informations for each row? If so you should use tFlowToIterate to process a tInput for each row.
Bye
Volker
Employee

Re: SQL query on tMap output

For an update, an insert, or a delete, it's quite easy.
Let's simply continue the flow with a tOracleRow
.... -> tMap -> tOracleRow
Answer is really different and a little more complicate for a select if you wan to get the results back :
.... -> tMap -> tOracleRow -> tParseRecordSet -> ...
In your tMap, add a column named record
In tOracleRow Advanced Setting, check propagate record set (choose the record column)
In tParseRecordSet, reuse the record column
HTH,

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download