What is perform recovery?
Submitted by: AdministratorWhen the Informatica Server starts a recovery session, it reads the OPB_SRVR_RECOVERY table and notes the row ID of the last row committed to the target database.
The Informatica Server then reads all sources again and starts processing from the next row ID. For example, if the Informatica Server commits 10,000 rows before the
session fails, when you run recovery, the Informatica Server bypasses the rows up to 10,000 and starts loading with row 10,001.
By default, Perform Recovery is disabled in the Informatica Server setup. You must enable Recovery in the Informatica Server setup before you run a session so the
Informatica Server can create and/or write entries in the OPB_SRVR_RECOVERY table.
Submitted by: Administrator
The Informatica Server then reads all sources again and starts processing from the next row ID. For example, if the Informatica Server commits 10,000 rows before the
session fails, when you run recovery, the Informatica Server bypasses the rows up to 10,000 and starts loading with row 10,001.
By default, Perform Recovery is disabled in the Informatica Server setup. You must enable Recovery in the Informatica Server setup before you run a session so the
Informatica Server can create and/or write entries in the OPB_SRVR_RECOVERY table.
Submitted by: Administrator
Read Online Informatica Data Warehousing Job Interview Questions And Answers
Top Informatica Data Warehousing Questions
☺ | Explain What is batch and describe about types of batches? |
☺ | Explain How to import oracle sequence into Informatica? |
☺ | Explain How many types of dimensions are available in Informatica? |
☺ | What is the difference between informatics 7x and 8x and what is latest version? |
☺ | How to do unit testing in informatica? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |