Preface
The Transformation Language
Constants
Operators
Variables
Dates
Functions
- Function Categories
  - Aggregate Functions
  - Aggregate Functions and Nulls
    - Filter Conditions
  - Binary Functions
  - Character Functions
  - Conversion Functions
  - Data Cleansing Functions
  - Date Functions
  - Encoding Functions
  - Financial Functions
  - Numeric Functions
  - Scientific Functions
  - Special Functions
  - String Functions
  - Test Functions
  - Variable Functions
  - Window Functions
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- ASCII
- AVG
- BINARY_COMPARE
- BINARY_CONCAT
- BINARY_LENGTH
- BINARY_SECTION
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COMPRESS
- CONCAT
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DEC_HEX
- DECODE
- DECOMPRESS
- EBCDIC_ISO88591
- ENC_BASE64
- ENC_HEX
- ERROR
- EXP
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- ISNULL
- IS_DATE
- IS_NUMBER
- IS_SPACES
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOOKUP
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SETCOUNTVARIABLE
- SET_DATE_PART
- SETMAXVARIABLE
- SETMINVARIABLE
- SETVARIABLE
- SHA256
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- STDDEV
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TIME_RANGE
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_FLOAT
- TO_INTEGER
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- VARIANCE
Creating Custom Functions
Custom Function API Reference

Transformation Language Reference

10.4.0
- 10.5.1
- 10.5

Back Next

Building the Module on Windows

On Windows, you can use Microsoft Visual C++ to build the module.

To build the module on Windows:

Start Visual C++.

Click File > New.

In the New dialog box, click the Projects tab and select the Win32 Dynamic-Link Library option.

Enter its location.

In the Echo example, enter the following directory:

<Informatica Development Platform installation directory>\CustomFunctionAPI\samples\echo

Enter the name of the project.

You must use the module name specified for the custom function as the project name. In the Echo example, enter EchoDemo.

Click OK.

Visual C++ creates a wizard to define the project components.

In the wizard, select an empty DLL project and click Finish. Click OK in the New Project Information dialog box.

Visual C++ creates the project files in the directory you specified.

Click Project > Add To Project > Files.

Navigate up a directory level. This directory contains the procedure files you created. Select all .c files and click OK.

In the Echo example, add the Echo.c file.

Click Project > Settings.

Click the C/C++ tab, and select Preprocessor from the Category field.

In the Additional Include Directories field, enter the following path and click OK:

..; <Informatica Development Platform installation directory>\CustomFunctionAPI\samples\echo; ...

Click Build > Build <module_name>.dll or press F7 to build the project.

Visual C++ creates the DLL and places it in the debug or release directory under the project directory.

Step 4. Build the Modules

Rename Saved Search

Table of Contents

Transformation Language Reference

Transformation Language Reference

Building the Module on Windows

Building the Module on Windows