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

4740

---

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

2113

---

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

2442

---

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

2017

---

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

2050

---

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

2019

---

what is dynamic insert?

2210

---

what is pmrep command?

2440

---

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

1950

---

what are Lookup caches options? Including persistent caches.

1976

---

Difference between flat files and relational sources?

2245

---

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

1970

---

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

1965

---

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

2134

---

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?

1895

---