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
- 18893 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
explain one complex mapping with logic? sales project?
Explain the different dimensions.
How would you join a node to the already existing domain?
Implementation methodology
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is joiner transformation?
What is the meaning of up gradation of repository?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is main use of mapplet?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain informatica architecture - version 8 / 9
What is a predefined event?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
permutations of mapplet
What is the sql query overwrite in source qualifier in informatica
