External procedure transformation and Custom transformation

What is the difference between "external procedure transformation" and "custom transformation"?

Questions by fordtaurus

Showing Answers 1 - 2 of 2 Answers

phdsong

  • Aug 6th, 2008
 

Both transformations operate in conjunction with procedure your create outside of the Desinger interface to extend PowerCenter functionality. However, for external procedure transformation, you need to use the Transformation Exchange (TX) dynamic invocation interface built into PowerCenter. Using TX, you can create an Informatica External Procedure transformation and build it to an external procedure that you have developed. For custom transformation, you need to develop a procedure which uses the functions described in "Custom Transformation functions".

  Was this answer useful?  Yes

sarita.harsh

  • Mar 4th, 2009
 

The input and output functions occur separately in Custom Transformation. In External transformation both input and output  are done by the external procedure function and its parameter consist of all the ports of the transformation. This is because in Custom transformation the input rows need to be processed before outputting any output as it creates transformation applications such as sorting and aggregation.

The output function is a separate function that you must enter in the procedure code to pass output data to the PowerCenter Server.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions