This content has been marked as final. Show 3 replies
In ODI you have some thing called as Transaction line .
If you set the job to run in same Transaction line then ODI will issue a commit only when the whole job completes successfuly , else every thing will be rolled back . So your target database is in a consistent state all the time.