What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 13638 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 is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Under what condition selecting sorted input in aggregator may fail the session?
What is Cognos script editor?
What do you mean by channel change?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Please let me know how to make encryption and decryption with example?
What's the layout of parameter file (what does a parameter file contain?)?
What does refresh system mean, and what are its distinctive choice?
Explain why we use partitioning the session in informatica?
Separate from an archive server and a powerhouse?
When do you use sql override in a lookup transformation?
can u give example for factless fact table
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
