Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica Server cannot run recovery or when running recovery might RESULT in INCONSISTENT data.

If there is no recovery mode on in session and workflow failed in mid of execution then

1. Don’t truncate table immediately.
2. If there is large volume of data is PERFORMING by the load and more than 25% data has loaded then-if same workflow has multiple session then check particular session which caused to be failed and fire the delete COMMAND only to delete particular session data which has loaded and copy the session into new workflow and run only that session or dependent others.

Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica Server cannot run recovery or when running recovery might result in inconsistent data.

If there is no recovery mode on in session and workflow failed in mid of execution then