Answer / 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.

Answer / 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.

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

What is complex mapping?

0 Answers  

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

What is data merging,data cleansing,sampling?

4 Answers  

---

What is a sorter transformation?

0 Answers   Informatica,

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---