Answer / Ankush Arora

Informatica ETL (Extract, Transform, Load) tool is a data integration and data transformation platform used to automate the movement and cleansing of data between various sources and targets. It supports various data types, databases, applications, and clouds.

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

what is constraint based loading

2 Answers   IBM,

---

is it possible to index the data in cache of lkp transformation ?

1 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

Did u used latest transformations of 8.6.0? for what?

1 Answers  

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1 Answers   CTS,

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

How to update or delete the rows in a target, which do not have key fields?

1 Answers   Informatica,

---

Can you create a flatfile target

3 Answers   ABC,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

Write the different tools in the workflow manager?

1 Answers  

---