how do u handle performance issues in Informatica . where can u monitor the performance ?

4793

---

list and discuss two approaches for updation of target table in Informatica and how they are different.

2160

---

where are the log files generally stored.Can you change the path of the file.what can the path be?

2499

---

where is the cache (lookup, index) created and how can you see it.

2067

---

what are the session parameters? How do u set them?

2094

---

how do use session mapping parameters ?(in which transformation)

2086

---

what is dynamic insert?

2256

---

what is pmrep command?

2485

---

what happens if the info.server doesn't find the session parameter in the parameter file?

2000

---

what are Lookup caches options? Including persistent caches.

2029

---

Difference between flat files and relational sources?

2295

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2018

---

how would u estimate the size of Aggregator transform data and index cache?

2010

---

how would u estimate the size of Lookup transform data and index cache?

2202

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1948

---