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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend