If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?

Answer Posted / rama krishna

Hey man ... first ofall u should need to mention that,
wether u r applied any commit or not.
with out apply any commit, How can u recover the session
yar?
ur quwstion is not valid. if u want exactly improve the
performence, then u must use commit points& commit
intervels.
if u really apply any commit,then if it fail according to u
at 10000 records, then u can recover remaining records by
using OPB_SRVR_RECOVERY table.

Hai friends am i correct ? think once

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between a database and data warehouse?

660


How would you join a node to the already existing domain?

696


How to do the error handling of if ur source is flatfiles?

1519


What is dynamic cache?

621


How to extract the informatica rejected data?

764






What is a repository manager?

660


Explain informatica architecture - version 8 / 9

681


What is Data Caches size?

668


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1530


To import the flat file definition into the designer where should the flat file be placed?

683


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1652


Can informatica load heterogeneous targets from heterogeneous sources?

705


What do you understand by term role-playing dimension?

596


How do you handle two sessions in Informatica

676


What are the different transaction levels available in transaction control transformation?

686