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
- 18875 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
Sequence generator, when you move from develoment to production how will you reset
Design a mapping to load the cumulative sum of salaries of employees into target table?
COM components can be used in Informatica
Separate from a database, an information bazaar, and an information stockroom?
What do you mean by blocking transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is informatica powercenter repository?
Explain target update override in informatica
What is the different lookup cache(s)?
Define pmcmd command?
Explain pushdown optimization and types in informatica
How can one identify whether mapping is correct or not without connecting session?
Explain incremental aggregation in informatica
scenario where i can use only concurrent execution of workflow.
What does command task mean?
