What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

scd methodology?

2 Answers  

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

What are the reusable transforamtions?

2 Answers  

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

---

Name the different lookup cache(s)?

0 Answers  

---