tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

---

How to go to the older version for a mapping?

0 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

What are batches?

0 Answers  

---

How to do unit testing in informatica?

0 Answers  

---

What are the differences between oltp and olap?

0 Answers  

---