Transformation Guide

Back Next

Step 1. Create the External Procedure Transformation

Open the Transformation Developer and create an External Procedure transformation.

Open the transformation and enter a name for it.

In the BankSoft example, enter

EP_extINF_BSFV

On the Ports tab, create a port for each argument passed to the procedure you plan to define.

Be sure that you use the correct datatypes.

The following table describes the ports:

Port Name	Datatype	Precision	Input/Output	Reusable
Rate	double	15	Input	No
nPeriods	integer	10	Input	No
Payment	double	15	Input	No
PresentValue	double	15	Input	No
PaymentType	integer	10	Input	No
FV	double	15	Output	Yes

The following BankSoft example shows an example of an External Procedure transformation:

Select the Properties tab and configure the procedure as an Informatica procedure.

In the BankSoft example, configure the following properties:

Transformation Attribute	Value
Type	Informatica
Module/Programmatic Identifier	INF_BankSoft
Procedure Name	FV
Runtime Location	$PMExtProcDir
Tracing Level	Normal
Is Partitionable	No
Output is Repeatable	Based On Input Order
Output is Deterministic	No

The following BankSoft example shows an example of an Informatica procedure:

on Module/Programmatic Identifier:

The following table describes how the module name determines the name of the DLL or shared object on the various platforms:

Operating System	Module Identifier	Library File Name
Windows	INF_BankSoft	INF_BankSoft.DLL
Linux	INF_BankSoft	libINF_BankSoft.so

Click OK.

After you create the External Procedure transformation that calls the procedure, the next step is to generate the C++ files.