Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14424 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 is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
What are the phases in SDLC?
what are the challenge face in u r project?explain me
What is the functionality of update strategy?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What are the challenges you have faced in your project?
how can we use sorter transformation in joins?
What are the diffrences between joiner transformation and source qualifier transformation?
What is facttable granularity?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
Can informatica load heterogeneous targets from heterogeneous sources?
Teradata 
