What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14613 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 |
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
Explain the difference between mapping parameter and mapping variable?
How many repositories can we create in Informatica??
How to Join Tables my Source is having 15 table target is one?
with out using update strategy transnsformation how to update the data in mapping level
what is song in infrmatica...?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
Why we select the table which has minimum number of records as Master table in joiner?
Differentiate between reusable transformation and mapplet.
What is meant by query override?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Whats the difference between $, $$, $$$
Teradata 
