Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14430 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 are the new features of the server manager in the informatica 5.0?
can you use flat file for lookup table?why?
4 yrs etl devloper roles and responsibilities?any body give solutions
how can one eliminate dupliacte data with out using distinct option?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Describe an informatica powercenter?
what happens if you try to create a shortcut to a non- shared folder?
What is a mapplet/worklet in informatica?
What are the new features of informatica 9.x in developer level?
How do you load first and last records into target table?
What are the mapings that we use for slowly changing dimension table?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
Teradata 
