Answer Posted / santoshi

its informatica utility

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1577

---

Define Pmrep command?

1050

---

Performance tuning( what you did in performance tuning)

1977

---

what is the hint? how to use it to reduce the query processing in program?

7816

---

What are the components of Informatica? And what is the purpose of each?

1053

---

How do you promote a non-reusable transformation to reusable transformation?

1132

---

What is complex mapping?

1115

---

What are Dimensional table?

1053

---

Explain lookup transformation in informatica

1070

---

Differentiate between source qualifier and filter transformation?

1572

---

Explain the mapping variable usage example in informatica

1155

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1062

---

What are the informatica performance improvement tips

1089

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1050

---

Tell me about MD5 functions in informatica

927

---