why union is active transformation?

4 Answers   IBM,

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

What is hash partition?

1 Answers  

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

What is persistent lookup cache?

0 Answers  

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---