how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers  

---

Do we need an ETL tool? When do we go for the tools in the market?

0 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 Answers  

---

What are your responsibilities as an etl tester?

0 Answers  

---

State the differences between shortcut and reusable transformation

0 Answers  

---

What is data cleaning?

0 Answers  

---

When do we go for the tools in the market?

0 Answers  

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  

---

Explain etl mapping sheets?

0 Answers  

---

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,

---