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 STOP and ABORT options in Workflow Monitor?
How do you load only null records into target? Explain through mapping flow.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Mention a few design and development best practices for informatica?
draw informatica architecture 8.6 ?
Explain what are the different versions of informatica?
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 ?
Informatica settings are available in which file?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How do you change a non-reusable transformation to reusable transformation?
what is the difference between informatica6.1 and infomatica7.1
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is dynamic cache?
How many number of sessions can one group in batches?