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

What is the difference between STOP and ABORT options in Workflow Monitor?

950


How do you load only null records into target? Explain through mapping flow.

1775


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?

827


what are factless facts? And in which scenario will you use such kinds of fact tables.

1527


Mention a few design and development best practices for informatica?

749


draw informatica architecture 8.6 ?

3644


Explain what are the different versions of informatica?

862


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 ?

2132


Informatica settings are available in which file?

777


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

1728


How do you change a non-reusable transformation to reusable transformation?

808


what is the difference between informatica6.1 and infomatica7.1

1929


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

1365


What is dynamic cache?

792


How many number of sessions can one group in batches?

900