Answer / swetha

If you configure a session in a sequential batch to stop on
failure, you can run recovery starting with the failed
session. The Informatica Server completes the session and
then runs the rest of the batch. Use the Perform Recovery
session property

To recover sessions in sequential batches configured to stop
on failure:

1.In the Server Manager, open the session property sheet.

2.On the Log Files tab, select Perform Recovery, and click OK.

3.Run the session.

4.After the batch completes, open the session property sheet.

5.Clear Perform Recovery, and click OK.

If you do not clear Perform Recovery, the next time you run
the session, the Informatica Server attempts to recover the
previous session.

If you do not configure a session in a sequential batch to
stop on failure, and the remaining sessions in the batch
complete, recover the failed session as a standalone session.

who to split dimentions into sub dimention

3 Answers   Wipro,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

What is metadata reporter?

1 Answers   Informatica,

---

How is union transformation utilized?

0 Answers  

---

---

In how many ways we can create ports?

0 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

---

Kimball and Inmon methodologies?

2 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---