topic SQL query on tMap output in Talend Studio

SQL query on tMap output

Anonymous — Sat, 16 Nov 2024 14:02:52 GMT

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.

Re: SQL query on tMap output

Anonymous — Mon, 09 Mar 2009 19:55:40 GMT

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

Re: SQL query on tMap output

Anonymous — Mon, 09 Mar 2009 20:00:53 GMT

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,