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
Differentiate between a database and data warehouse?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is meant by lookup transformation? Explain the types of lookup transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
Enlist some properties of sessions.
How to load last n records of file into target table - informatica
What are the components of workflow manager?
Define filter transformation?
What are roles and groups and benefits of using them?
Enlist the tasks for which source qualifier transformation is used.
lookup transformation with screenshots
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain the difference between a data warehouse and a data mart?
What are the different lookup cache(s)?
What is Cognos script editor?