If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
Answer Posted / bsgsr
simple. in session properties configure the session to
enable recovery. it then create s a database log file which
contains the rowids ot all records committed to the target.
when you run recovery session it checks with the log file
the last rowid committed to the target and writes to the
target from the next rowid. condition the session is
configured to run in a normal mode.
| Is This Answer Correct ? | 42 Yes | 0 No |
Post New Answer View All Answers
Define mapplet?
What are the issues you have faced in your project? How did you overcome those issues?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Define sessions in informatica etl?
What is powercenter on grid?
What is repository manager?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is event and what are the tasks related to it?
What are the advantages of using informatica as an etl tool over teradata?
What are multi-group transformations?
Differentiate between sessions and batches?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What do you understand by SOA of Informatica?
How to Create a folder using pmrep command?
Define joiner transformation?