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
Is there any target staging area in informatica not staging area
Differences between version 7.x and 8.x.
Explain what are the different types of transformation available in informatica.
Informatica settings are available in which file?
What is the difference between source qualifier transformations source filter to filter transformation?
Whats there in global repository
Is stop and abort are same in informatica?
What is mapplet in informatica?
How to create a non-reusable instance of reusable transformations?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the reusable transformation?
How can we improve session performance in aggregator transformation?
How can we update a record in the target table without using update strategy?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
difference between repository database and repository service?