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
What is the difference between writing a joiner query in ANSI style and THETA style?
Write the unconnected lookup syntax?
Did u used latest transformations of 8.6.0? for what?
Describe expression transformation?
Write the program through which the records can be updated?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How do you use reject loader.
What are different types of transformations available in informatica?
What is the meaning of up gradation of repository?
Reusable transformation and shortcut differences
can we override a native sql query within informatica? How do we do it?
What are the mapping parameters and mapping variables?
Explain pmcmd command usage in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is index?how it can work in informatica