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
Explian the Process of deployment groups in informatica
What is a difference between complete, stop and abort?
What is mapplet in informatica?
How can we use mapping variables in informatica?
Write the advantages of partitioning a session?
How to do unit testing in informatica? How to load data in informatica ?
Please let me know how to make Data masking in informatica..
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Name the different lookup cache(s)?
what is the difference between informatica6.1 and infomatica7.1
Describe the impact of several join conditions and join order in a joiner transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a surrogate key?
How to load a Dimension ? and how to load a fact table?