What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 13640 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is lookup transformation?
What is the difference between informatica 7.0 and 8.0?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can informatica load heterogeneous targets from heterogeneous sources?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What are the methods for creating reusable transforamtions?
Explain the types of transformations?
How many repositories can we create in Informatica?
Teradata 
