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

0 Answers  

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

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

1 Answers   HP,

---

What is event and what are the tasks related to it?

0 Answers  

---

explain abt union t/r?

1 Answers   IBM,

---

what is update strategy transformation ?

7 Answers   TCS,

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

Explain the use of aggregator cache file?

0 Answers  

---

what is incremental data aggregation?

3 Answers   IBM,

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

can you use flat file for repository?why?

2 Answers   TCS,

---