Interested to Buy Any Domain ? << Click Here >> for more details...
If a session fails after loading of 10,000 records in to the
target. How can you load the records from 10001 th record
when u run the session next time?
- 4 Answers
- 18711 Views
- I also Faced
- E-Mail Answers
Answer Posted / rekha
U CAN DO IT BY PERFORMANCE RECOVERY
WHEN THE SERVER RUNS THE RECOVERY SESSION , SERVER READS
THE DATA FROM OPR_SRVR_RECOVERY TABLE AND NOTES THE ROW ID
OF THE LAST ROW COMMITTED TO THE TARGET TABLE ,THEN
INFORMATICASERVER READS THE ENTIRE SOURCE AGAIN AND PROCESS
THE DATA FROM NEXT ROW
BY DEFAULT PERFORMANCE RECOVERY IS DISABLE ,HENCE IT WONT
MAKE ANT ENTRIES IN TO OPR_SRVR_RECOVERY TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is aggregate cache in aggregator transformation?
is it possible to index the data in cache of lkp transformation ?
What is workflow manager?
How is union transformation utilized?
What is meant by pre and post session shell command?
What is joiner change?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How many number of sessions can one group in batches?
What is the reusable transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What is the sql query overwrite in source qualifier in informatica
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to load the data from people soft hrm to people soft erm using informatica?
