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

0 Answers  

---

Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  

---

what are Lookup caches options? Including persistent caches.

1 Answers  

---

Explain different types of partitioning?

0 Answers  

---

what is the meant by Normalization and de-normalization?

0 Answers  

---

---

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  

---

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

2 Answers  

---

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

2 Answers   Accenture,

---

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

---

Explain about enterprise scalability and roi of data integration suite?

0 Answers  

---

how does the server recongnise the source and target databases.Elaborate on this

0 Answers   Accenture,

---

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,

---