If a workflow stops or fails after loading 10k records ? How can you recover i

If a workflow stops or fails after loading 10k records ?
How can you recover it and If there is no order while
reading data from source ?

Question Posted / manojkumar challagundla

2 Answers
9008 Views
IBM, WalMart, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no..

Answer / abhinaw prakash

Informatica has something called Recovery option for
recovering data.
If we have provided commit after say 10k records then it ll
start from where it failed i.e @ 10k.

Is This Answer Correct ?

9 Yes

1 No

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no..

Answer / prateek singh rana

informatica has one property in session level called
recovery stragy, we use it and take as ''resume from last
check point'' and run the workflow on recovery mode.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Informatica Interview Questions

How to create the source and target database connections in server manager?

0 Answers Informatica,

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers

Which development components of informatica have the highest usage?

0 Answers

Explain the different lookup methods used in informatica?

0 Answers

what are types of dimentions?

3 Answers

What are the scheduling options to run a sesion?

2 Answers

Explain the mapping variable usage example in informatica

0 Answers Informatica,

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers TCS,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers Span Systems,

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers Accenture,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers

For more Informatica Interview Questions Click Here