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