satoru

 Profile Answers by satoru 

• Jun 30th, 2010

 

In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database.

Before a user receives a "Commit complete" message, the system must first successfully write the new or changed data to a redo log file.

If a database crashes, the recovery process has to apply all transactions, both uncommitted as well as committed, to the data-files on disk, using the information in the redo log files. Oracle must re-do all redo-log transactions that have both a begin and a commit entry, and it must undo all transactions that have a begin entry but no commit entry.

Maybe it's the same thing with Informatica?

jayapraveen

 Profile Answers by jayapraveen 

• Oct 3rd, 2010

 

Redo log file keeps the value when the "commit"command executes and replaces the value with new value.