Answer Posted / manjunath

Stored procedure transformation is used to invoke the database procedure or function stored in the database. it needs the connection to the database. Where as the external procedure transformation is used to invoke the application function developed either in C/C++/VB.The external procedure needs to be bind with the external procedure transformation in the designer so the the application function would be loaded at the run time like a DDL.

draw informatica architecture 8.6 ?

3867

---

explain one complex mapping with logic? sales project?

6656

---

How to do unit testing in informatica? How to load data in informatica ?

1108

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6162

---

Explain joiner transformation in informatica

1117

---

Define pmcmd command?

1032

---

What do you mean by filter transformation?

945

---

How would you join a node to the already existing domain?

1117

---

what are the Methods For Creating Reusable Transformations?

1161

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2355

---

can we override a native sql query within informatica? How do we do it?

1117

---

When do you use sql override in a lookup transformation?

1085

---

permutations of mapplet

2502

---

What are data-driven sessions?

1191

---

tell me about your project functionality

2337

---