Answer Posted / nagaraju bhatraju
when we use concurrent process to load when session
fails ...all other session will run normally and load the
data..the failed session will considered as a standalone
sesion ...and we have perform recovery for the failed
session.
there three type where we can recover a failed session
1.start the session again if the Informatica server doesnt
perform the commit
2.else perform recovery on the session
3. if we can recover the session truncacte the data from
target table and run the session.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is a standalone command task?
What are some examples of informatica etl programs?
What is powercenter on grid?
How to update or delete the rows in a target, which do not have key fields?
permutations of mapplet
Is it possible to define a single node as a Gateway node as well as worker node?
How to do the error handling of if ur source is flatfiles?
Explain transaction control transformation in informatica
What are the different ways to implement parallel processing in informatica?
Why update strategy and union transformations are active? Explain with examples.
EXL informatica Questions
Explain the different kinds of facts.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can we override a native sql query within informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.