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


Please Help Members By Posting Answers For Below Questions

Explain pushdown optimization and types in informatica

668


Difference between Data and Index Caches?

653


How an expression transformation differs from aggregator transformation?

626


What is a connected transformation?

674


What is a code page?

712






Is it possible to use a client with different version than that of its Informatica server?

643


How many ways are there to create ports?

727


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What is pmcmd command?

675


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7766


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1916


What is confirmed fact in dataware housing?

5681


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

675


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1761


How can informatica be used for an organization?

653