Answer / Siddhartha Chaturvedi

In Informatica, you can delete duplicate rows by using a Sort transformation followed by a Delete transformation or by using a Script Transformation.

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

Explain informatica architecture - version 8 / 9

1 Answers   Informatica,

---

How are parameters defined in informatica?

3 Answers   HP, TCS,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

Can you copy the session to a different folder or repository?

2 Answers  

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1 Answers  

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

What is target load order?

1 Answers  

---

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---