Developer Mapping Guide

Back Next

Function Support in Queries that Generate a Mapping

Informatica supports functions that meet the ANSI SQL-92 standard.

In addition, some functions have specific syntax requirements.

The following table lists the functions and supported syntax:

Function	Syntax
DATE( )	To specify the format of a date: DATE(format '<format>') where <format> is a standard date format. Example: SELECT DATE(format 'dd-mm-yyyy') from table
POSITION( )	To determine the position of a substring in a literal string: POSTITION('<substring>', '<string>' ) Example: POSITION('MA', 'James Martin') To determine the position of a substring in a table column: POSTITION('<substring>', <column_name> ) Example: POSITION('MA', FULL_NAME)