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!!!
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,
