Transformation Guide

Back Next

Step 1. Create the Custom Transformation

To create a Custom transformation:

In the Transformation Developer, click Transformation > Create.

In the Create Transformation dialog box, choose Custom transformation, enter a transformation name, and click Create.

In the Union example, enter

CT_Inf_Union

as the transformation name.

In the Active or Passive dialog box, create the transformation as a passive or active transformation, and click OK.

In the Union example, choose Active.

Click Done to close the Create Transformation dialog box.

Open the transformation and click the Ports tab. Create groups and ports.

You can edit the groups and ports later, if necessary.

The following figure shows an example of a Union transformation with two groups:

The Ports tab in the Edit Transformations dialog box contains two input groups. The input groups contain the port name, datatype, precision, and scale columns.

In the Union example, create the groups InputGroup1 and InputGroup2. Create the following ports for InputGroup1:

Port Name	Datatype	Precision	Scale
ORDER_ID1	integer	10	0
ORDER_DATE1	date/time	19	0
TOTAL_PRICE1	decimal	10	2

Create the following ports for InputGroup2:

Port Name	Datatype	Precision	Scale	Input/Output
ORDER_ID2	integer	10	0	Input
ORDER_DATE2	date/time	19	0	Input
TOTAL_PRICE2	decimal	10	2	Input
ORDER_ID_OUT	integer	10	0	Output
ORDER_DATE_OUT	date/time	19	0	Output
TOTAL_PRICE_OUT	decimal	10	2	Output

Select the Properties tab and enter a module and function identifier and the runtime location. Edit other transformation property attributes, such as the Tracing Level, Is Partitionable, Inputs Must Block, Is Active, Update Strategy Transformation, Transformation Scope and Generate Transaction values/checkboxes.

In the Union example, configure the following properties:

Property Name	Value
Module Identifier	UnionDemo
Function Identifier	Union
Runtime Location	$PMExtProcDir
Tracing Level	Normal
Is Partitionable	No
Inputs Must Block	No
Is Active	Yes
Update Strategy Transformation	No
Transformation Scope	All Input
Generate Transaction	No

Click the Metadata Extensions tab to enter metadata extensions, such as properties the external procedure might need for initialization.

In the Union example, do not create metadata extensions.

Click the Port Attribute Definitions tab to create port attributes, if necessary.

In the Union example, do not create port attributes.

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

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Step 1. Create the Custom Transformation

Step 1. Create the Custom Transformation