Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14290 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 are the designer tools for creating transformations?
Write the advantages of partitioning a session?
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?
What are different types of transformations available in informatica?
What is InformaticaPowerCenter?
How can we use mapping variables in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are ETL Tools?
Did u used latest transformations of 8.6.0? for what?
What is session task and command task?
What are the components of the workflow manager?
Explain Dataware house architecture .how data flow from intial to end?
Where do we use mapping variables in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
