Explain about Recovering sessions?



Explain about Recovering sessions?..

Answer / swetha

If you stop a session or if an error causes a session to
stop, refer to the session and error logs to determine the
cause of failure. Correct the errors, and then complete the
session. The method you use to complete the session depends
on the properties of the mapping, session, and Informatica
Server configuration.

Use one of the following methods to complete the session:

Run the session again if the Informatica Server has not
issued a commit.

Truncate the target tables and run the session again if the
session is not recoverable.

Consider performing recovery if the Informatica Server has
issued at least one commit.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is xml source qualifier transformation in informatica?

0 Answers  


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,


what is mean by flag 4 in update strategy t/r

6 Answers  


can we override a native sql query within informatica? Where do we do it?

0 Answers  






The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,


what are testing in a mapping level please give brif eplanation

1 Answers   CTS,


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,


I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,


can we see default group,when we use router?if yes how?

2 Answers   L&T,


What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


What are the new features of the server manager in the informatica 5.0?

1 Answers  


Categories