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
Explain pushdown optimization and types in informatica
Difference between Data and Index Caches?
How an expression transformation differs from aggregator transformation?
What is a connected transformation?
What is a code page?
Is it possible to use a client with different version than that of its Informatica server?
How many ways are there to create ports?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is pmcmd command?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is confirmed fact in dataware housing?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
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.
How can informatica be used for an organization?