Preface
Informatica Resources
Informatica Network
Informatica Knowledge Base
Informatica Documentation
Informatica Product Availability Matrixes
Informatica Velocity
Informatica Marketplace
Informatica Global Customer Support
The Transformation Language
The Transformation Language Overview
Transformation Language Components
Internationalization and the Transformation Language
Expression Syntax
Expression Components
Rules and Guidelines for Expression Syntax
Adding Comments to Expressions
Reserved Words
Operators
Variables
Built-in Variables
$PM<SourceName>@TableName, $PM<TargetName>@TableName
$PMFolderName
$PMIntegrationServiceName
$PMMappingName
$PMRepositoryServiceName
$PMRepositoryUserName
$PMSessionName
$PMSessionRunMode
$PMWorkflowName
$PMWorkflowRunId
$PMWorkflowRunInstanceName
SESSSTARTTIME
SYSDATE
WORKFLOWSTARTTIME
Transaction Control Variables
Local Variables
Dates
Dates Overview
Date/Time Datatype
Julian Day, Modified Julian Day, and the Gregorian Calendar
Dates in the Year 2000
Dates in Relational Databases
Dates in Flat Files
Default Date Format
Date Format Strings
TO_CHAR Format Strings
Examples
TO_DATE and IS_DATE Format Strings
Rules and Guidelines for Date Format Strings
Example
Understanding Date Arithmetic
Functions
ADD_TO_DATE
ASCII
CEIL
CHOOSE
CHRCODE
COMPRESS
CONCAT
CONVERT_BASE
CRC32
DATE_COMPARE
DATE_DIFF
DEC_BASE64
DECODE
DECOMPRESS
FLOOR
GREATEST
IIF
IN
INDEXOF
INITCAP
INSTR
ISNULL
IS_DATE
IS_NUMBER
IS_SPACES
LEAST
LOWER
LPAD
LTRIM
MAKE_DATE_TIME
MAX (Numbers)
MD5
METAPHONE
MOD
POWER
REG_EXTRACT
REG_MATCH
REG_REPLACE
REPLACECHR
REPLACESTR
REVERSE
ROUND (Dates)
ROUND (Numbers)
RPAD
RTRIM
SET_DATE_PART
SIGN
SOUNDEX
SQRT
SUBSTR
SYSTIMESTAMP
TO_BIGINT
TO_CHAR (Dates)
TO_CHAR (Numbers)
TO_DATE
TO_DECIMAL
TO_FLOAT
TO_INTEGER
TRUNC (Dates)
TRUNC (Numbers)
UPPER
Preface
UPPER
HIDD_EXPRESSION_COMMENTS
HIDX_3DOLLAR_SESSSTARTTIME
HIDD_PMSourceNameAtTableName
HIDD_PMTargetNameAtTableName
HIDD_PMFolderName
HIDD_PMIntegrationServiceName
HIDD_PMMappingName
HIDD_PMRepositoryServiceName
HIDD_PMRepositoryUserName
HIDD_PMSessionName
HIDD_PMSessionRunMode
HIDD_PMWorkflowName
HIDD_PMWorkflowRunId
HIDD_PMWorkflowRunInstanceName
HIDX_SESSSTARTTIME
HIDX_FUNCPROTO_IIF
HIDX_SYSDATE
HIDX_WORKFLOWSTARTTIME
HIDX_FUNC_ADD_TO_DATE
HIDX_FUNCDESC_ADD_TO_DATE
HIDX_FUNCPROTO_ADD_TO_DATE
HIDX_FUNC_ASCII
HIDX_FUNCPROTO_ASCII
HIDX_FUNCDESC_ASCII
HIDX_FUNCDESC_CEIL
HIDX_FUNC_CEIL
HIDX_FUNCPROTO_CEIL
HIDD_FUNC_CHOOSE
HIDX_FUNCDESC_CHRCODE
HIDX_FUNC_CHRCODE
HIDX_FUNCPROTO_CHRCODE
HIDD_FUNC_COMPRESS
HIDX_FUNC_CONCAT
HIDX_FUNCPROTO_CONCAT
HIDX_FUNCDESC_CONCAT
HIDD_FUNC_CONV
HIDD_FUNC_CRC32
HIDX_FUNC_DATE_COMPARE
HIDX_FUNCPROTO_DATE_COMPARE
HIDX_FUNCDESC_DATE_COMPARE
HIDX_FUNC_DATE_DIFF
HIDX_FUNCDESC_DATE_DIFF
HIDX_FUNCPROTO_DATE_DIFF
HIDD_FUNC_DEC_BASE64
HIDX_FUNC_DECODE
HIDX_FUNCDESC_DECODE
HIDX_FUNCPROTO_DECODE
HIDD_FUNC_DECOMPRESS
HIDX_FUNC_FLOOR
HIDX_FUNCDESC_FLOOR
HIDX_FUNCPROTO_FLOOR
HIDD_FUNC_GREATEST
HIDX_FUNCDESC_IIF
HIDX_FUNC_IIF
HIDD_FUNC_IN
HIDD_FUNC_INDEXOF
HIDX_FUNC_INITCAP
HIDX_FUNCDESC_INITCAP
HIDX_FUNCPROTO_INITCAP
HIDX_FUNC_INSTR
HIDX_FUNCDESC_INSTR
HIDX_FUNCPROTO_INSTR
HIDX_FUNC_ISNULL
HIDX_FUNCPROTO_ISNULL
HIDX_FUNCDESC_ISNULL
HIDX_FUNCDESC_IS_DATE
HIDX_FUNCPROTO_IS_DATE
HIDX_FUNC_IS_DATE
HIDX_FUNCPROTO_IS_NUMBER
HIDX_FUNC_IS_NUMBER
HIDX_FUNCDESC_IS_NUMBER
HIDX_FUNCDESC_ISSPACES
HIDX_FUNCPROTO_ISSPACES
HIDX_FUNC_ISSPACES
HIDD_FUNC_LEAST
HIDX_FUNCDESC_LOWER
HIDX_FUNCPROTO_LOWER
HIDX_FUNC_LOWER
HIDX_FUNCDESC_LPAD
HIDX_FUNC_LPAD
HIDX_FUNCPROTO_LPAD
HIDX_FUNCDESC_LTRIM
HIDX_FUNC_LTRIM
HIDX_FUNCPROTO_LTRIM
HIDD_FUNC_MAKE_DATE_TIME
HIDX_FUNC_MAX
HIDX_FUNCPROTO_MAX
HIDD_FUNC_MD5
HIDX_FUNCDESC_METAPHONE
HIDX_FUNCDESC_MOD
HIDX_FUNC_MOD
HIDX_FUNCPROTO_MOD
HIDX_FUNCPROTO_POWER
HIDX_FUNCDESC_POWER
HIDX_FUNC_POWER
HIDD_FUNC_REG_EXTRACT
HIDD_FUNC_REG_MATCH
HIDD_FUNC_REG_REPLACE
HIDX_FUNCDESC_REPLACECHR
HIDX_FUNC_REPLACECHR
HIDX_FUNCPROTO_REPLACECHR
HIDX_FUNCDESC_REPLACESTR
HIDX_FUNC_REPLACESTR
HIDX_FUNCPROTO_REPLACESTR
HIDD_FUNC_REVERSE
HIDX_FUNCPROTO_ROUND
HIDX_FUNC_ROUND
HIDX_FUNCDESC_ROUND2
HIDX_FUNCDESC_ROUND
HIDX_FUNC_ROUND2
HIDX_FUNCPROTO_ROUND2
HIDX_FUNC_RPAD
HIDX_FUNCDESC_RPAD
HIDX_FUNCPROTO_RPAD
HIDX_FUNCDESC_RTRIM
HIDX_FUNC_RTRIM
HIDX_FUNCPROTO_RTRIM
HIDX_FUNC_SET_DATE_PART
HIDX_FUNCPROTO_SET_DATE_PART
HIDX_FUNCDESC_SET_DATE_PART
HIDX_FUNC_SIGN
HIDX_FUNCDESC_SIGN
HIDX_FUNCPROTO_SIGN
HIDX_FUNCDESC_SOUNDEX
HIDX_FUNC_SQRT
HIDX_FUNCDESC_SQRT
HIDX_FUNCPROTO_SQRT
HIDX_FUNCPROTO_SUBSTR
HIDX_FUNCDESC_SUBSTR
HIDX_FUNC_SUBSTR
HIDX_FUNC_SYSTIMESTAMP
HIDX_FUNCDESC_TO_BIGINT
HIDX_FUNCDESC_TO_CHAR2
HIDX_FUNC_TO_CHAR
HIDX_FUNCPROTO_TO_CHAR
HIDX_FUNCDESC_TO_CHAR
HIDX_FUNCPROTO_TO_CHAR2
HIDX_FUNC_TO_CHAR2
HIDX_FUNCPROTO_TO_DATE
HIDX_FUNCDESC_TO_DATE
HIDX_FUNC_TO_DATE
HIDX_FUNCPROTO_TO_DECIMAL
HIDX_FUNCDESC_TO_DECIMAL
HIDX_FUNC_TO_DECIMAL
HIDX_FUNCDESC_TO_FLOAT
HIDX_FUNC_TO_FLOAT
HIDX_FUNCPROTO_TO_FLOAT
HIDX_FUNCPROTO_TO_INTEGER
HIDX_FUNCDESC_TO_INTEGER
HIDX_FUNC_TO_INTEGER
HIDX_FUNC_TRUNC
HIDX_FUNCPROTO_TRUNC
HIDX_FUNCDESC_TRUNC2
HIDX_FUNCPROTO_TRUNC2
HIDX_FUNC_TRUNC2
HIDX_FUNCDESC_TRUNC
HIDX_FUNCDESC_UPPER
HIDX_FUNC_UPPER
HIDX_FUNCPROTO_UPPER