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 mean by flag 4 in update strategy t/r

6 Answers  

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

How to retrieve last two days updated records?

4 Answers  

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

what is the use of Data Mart?

5 Answers   IBM,

---

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

How the facts will be loaded? explain

2 Answers   HCL,

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---