Answer / krishna

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.

Answer / aswin

Its purely depending on the way the design involved..Recovery strategy is not possible with flatfile targets..If commit happens inbetween, there is no point in running session from beginning

so manual intervention is required to restat the flatfile target load fails

Answer / seshagiri k

by removing the target table and run the session again

if it is wrong pls send the answer to my mail

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

What are the tasks that source qualifier performs?

1 Answers  

---

What are the reusable transformations?

0 Answers   Informatica,

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

what is plsql table?

2 Answers  

---

design of staging area?

0 Answers  

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---