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
- 18739 Views
- I also Faced
- E-Mail Answers
Answer Posted / srini
By setting session property as Resume last check point you
can acheive the same.Make sure that all recovery tables
PM_RECOVERY,PM_TGT_RUN_ID is created in the target database
or Realtion connection User have the
create,grant,insert,update previliages on target database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
which one is better performance wise joiner or look up
COM components can be used in Informatica
How are the sources and targets definitions imported in informatica designer?
Explain sessions?
What is source qualifier transformation in informatica?
What is Data Caches size?
What is the difference between writing a joiner query in ANSI style and THETA style?
Please let me know how to make encryption and decryption with example?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain sessions and how many types of sessions are there?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is option by which we can run all the sessions in a batch simultaneously?
What is parallel processing in informatica?
How can we remove the duplicates from flat file source?
