I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

What you know about transaction control transformation?

0 Answers  

---

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

---

how did u understand business requirement?

2 Answers   TCS,

---

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

what is a transforamation?

5 Answers  

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---