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?

Answers were Sorted based on User's Feedback



If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / 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

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / srikanth

Select the recovery strategy in session properties as
"Resume from the last chk point"

Is This Answer Correct ?    10 Yes 4 No

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / guest

using performance recovery to load the target

they are 3 types of performance recovery

1 ) we enable the recovery option in session

2) we put a commit intervel point in session

3) trancate the target and load once again

Is This Answer Correct ?    3 Yes 0 No

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / lathagarat

First we will get the how many records was loaded in the
target system i.e max(records) (using aggregate
transformation we can get)and incremented from there
onwards.

Is This Answer Correct ?    4 Yes 1 No

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / chaitanya

On selecting lookup cache as PERSISTENT we can able to use same cache for next session also.

Is This Answer Correct ?    3 Yes 0 No

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / gayathri

In session properties we have "suspend on error" option is
there. It starts from the failed task not from the begining.

Is This Answer Correct ?    7 Yes 7 No

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / basu

I think his question is, he wants to loads incremental. so you can go for Change data capture by using mapping variable/parameters in the SQ query overid

Is This Answer Correct ?    0 Yes 0 No

If session fails after loading 10000 records in the target,how can we load 10001 th record when w..

Answer / nidhi

As per me Mr.Rama Krishna is right, every one else is ...
Ms. latha he already mentioned like after loading 10000
records, so there is no need to check again the
max(records),but incremental loading is also one of the ways
i guess..


1)Session recovery
2)Incremental loading are the ways as per my knowledge..

If any 1 think i am wrong plz let me knw..

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Informatica Interview Questions

What is the functionality of update strategy?

2 Answers  


If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


Kimball and Inmon methodologies?

2 Answers  


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  






How do you implement unconn. Stored proc. In a mapping?

1 Answers  


Informatica and datawarehousing courses in Pune?

2 Answers  


What is synonym?

2 Answers   Patni,


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


What are the different options used to configure the sequential batches?

2 Answers   Wipro,


How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  


How can we create index after completion of load process?

0 Answers  


Categories