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.

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

What is domain and gateway node?

0 Answers  

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

What is the difference between view and materialised view?

4 Answers  

---

How can informatica be used for an organization?

0 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---