Answer / 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.

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

what is lookup chache?

1 Answers   Patni,

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

what are the types of Data warehousing ?

1 Answers  

---

What is the Router transformation?

2 Answers   Informatica,

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---