Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14546 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 types of error logs available in Informatica?
If you want to create indexes after the load process which transformation you choose?
What is meant by query override?
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.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
how do the project develops? pls specify right from the start to end in step by steps.
how to join two flat files in informatica?
What are the different options used to configure the sequential batches?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Teradata 
