tTeradataoutput

Highlighted
One Star

tTeradataoutput

Hi,
In my first job I am loading data in teradata table via tTeradataoutput component which gets loaded correctly. After that I have 10-15 jobs which are connected via link component ok or main which are working correctly.
Now I have added one job in last which has to update teradata table which has loaded via tTeradataoutput.
But I am not able to update that table. When pointer comes to last job it's got hanged and seems like teradata table is locked and I am not able to fire select statement on table. As I kill running job select statement executed but table is not updated.
If I use updation job exactly after table loading job then I am able to update it But I have many jobs in between and want to execute update job at last point.
-In updation job I am using tJDBCConnection----->tJDBCRow(contains update query)--------->tJDBCCommit
-In tTeradataoutput, I am usnig Commit every (1) and Batch Size(1)
-My teradata table contains only 100 records.
Please let me know solution for that.
Thanks!!!
One Star

Re: tTeradataoutput

It's resolved now. Actually I was having select statment on table in middle that is why it was not allowing me to update it at last. I have clicked auto commit box in tJDBCConnection component where I had select statement.
Thanks,

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read