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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema