Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2012 @ 17:23:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

James,

Transient journal is the table that is used to rollback failed transactions.

Transient journal would be used for inserts/deletes/updates.

When you delete rows from a table the rows will be placed into the transient journal so they can be put back into the original table if the delete query fails or is aborted. Once the insert/update/delete is complete/committed the rows are removed from the transient journal.

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA

	<Prev	Next>		<<First	<Prev	Next>	Last>>