in a tmap you can concatinate all the input columns into a sql statement: dbInput-->tMap-->fileOutput in the tMap output table, have a single column with something like this: Java: "INSERT INTO TABLE (COLUMN1,COLUMN2) VALUES (" + row1.column1 +","+ row1.column2 + ");" Perl: "INSERT INTO TABLE (COLUMN1,COLUMN2) VALUES ( $row1,$row1 );"
It exist also the SQLULDR2 utility to dump the data of your Oracle and other databases in a flat files, SQL format etc... You can call the utility from your Talend studio and it works fine.
