Does ODI support rollback on request or abnormal termination to ensure target database is in a consistent state?
Would appreciate if you could point share details with a documentation link
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.