SQL query on tMap output

Highlighted
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,

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.