Sample Header Ad - 728x90

How do I debug an ETL process that is unable to commit any records?

0 votes
1 answer
1035 views
I used a DB link to connect to another DB and delete a couple of records. Later I ran an Informatica Workflow (ETL tool) to load data into that database using a DB connection that connects directly to it. The Workflow hasn't committed any records since 2hrs (it should run just for 30mins or so..) so I am guessing it is because I was not able to run "commit" using the DB link. *The ETL tools logs don't provide any error or debug information at this point.* Any ideas how I could debug this..? I ran another ETL process to update a table and then run commit. But even after that the first process keeps on running without committing any records. I am not a DBA expert so probably am misinterpreting the DB behavior.. would really appreciate any suggestions. Thanks!
Asked by Kent Pawar (283 rep)
Feb 12, 2013, 05:51 PM
Last activity: Feb 12, 2013, 06:33 PM