Answer Posted / swetha

In case of storedprocedure transformation procedure will be
compiled and executed in a relational data source.yoU need
data base connection to import the stored procedure in to
your maping.Where as in external procedure transformation
procedure or function will be executed out side of data
source.Ie you need to make it as a DLL to access in your
maping.No need to have data base connection in case of
external procedure transformation.

What's the layout of parameter file (what does a parameter file contain?)?

2385

---

Write the prerequisite tasks to achieve the session partition?

1158

---

What is the status code in stored procedure transformation?

1182

---

How to create a non-reusable instance of reusable transformations?

1132

---

What is the difference between informatica 7.0 and 8.0?

1016

---

What is lookup change?

1048

---

What is a stored procedure transformation?

1053

---

How to convert multiple rows to single row (multiple columns) in informatica

1380

---

Enlist the tasks for which source qualifier transformation is used.

1040

---

Is it possible to define a single node as a Gateway node as well as worker node?

1122

---

What is difference between a gateway node and worker node?

1138

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

Differentiate between a database and data warehouse?

1143

---

Explain about cumulative Sum or moving sum?

1043

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

---