I have a similar issue as posted by Jijli early today. Table truncated but no data inserted. I have a simple job:
tOracleconnection_1 - property type, repository. Use or register a shared DB connection box check, and shared name entered.
tFileInputPositional_1 - pick up a fixed width text file with repository schema applied. limited 50 rows
tOracleOutput_1 - used an existing connection box checked. component list "tOracleconnection_1" in yellow color. Action on table - truncate, action on data- insert, schema-repository, die on error box checked. Dynamic setting, component list and tOracleConnection_1.
I ran it with no errors. I check the oracle table truncated but no data inserted. It works fine without using an existing connection.
Solved! Go to Solution.
Use or register a shared DB connection box check, and shared name entered.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables