Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14331 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 |
Do joiner transformation use cache? If so describe?
Which is the best place to learn Informatica Powercenter Online Training?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
what is confirmed dimension?
In informatics server which files are created during the session rums?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
how can we calculate fact table size?
What is the need for an etl tool?
What is diff joiner and lookup
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Teradata 
