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 ?

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

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,


i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,


How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,


Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  






What are the new features of informatica 9.x developer?

0 Answers  


What are the different components of powercenter?

0 Answers  


Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,


What is olap (on-line analytical processing?

0 Answers  


There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


Categories