What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 13404 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
When do you use sql override in a lookup transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Separate from an archive server and a powerhouse?
Differentiate between sessions and batches?
Write the unconnected lookup syntax and how to return more than one column.
what is unit testing?tell me proceedure
r u done any partitions in ur project?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is an expression transformation?
What are the types of presistent cache in look up tr.
what is size of u r database?
On which transformations you created partitions in your project?
scenario where i can use only concurrent execution of workflow.
What is decode in static cache?
