How to convert a query results to a new table?

[wzhu]

Hello,

I am new to Talend. I need help how I can make the following happen:

1. Create a query C by joining table A and table B from a data source (Oracle DB)
2. Convert query C results to a new table ( table C) in destination (Postgresql DB)

I have seen people did this without using tMap, but just used tDBinput / tDBoutput. can someone share what tool I can use to handle query from multiple tables and then convert the query results to a new table in destination DB?

Many thanks!

David

[Anonymous]

Hello,

Could you please have a look at this related topic to see if it helps?

https://community.talend.com/s/question/0D53p00007vCnvLCAS/microsoft-sql-to-mysql-data-insertion-bas...

Best regards

Sabrina