About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.5
- 6.5.1
- 6.5 HotFix 1
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Functions Overview

A function is a named, specialized operation performed on zero or more input values, that returns a single value when executed successfully. A function can appear anywhere a value expression is permitted. The function is invoked by its name, followed by the input arguments in parentheses.

The following table describes the types of functions that you can use:

Function Type	Description
Aggregate	An operation applied to the values contained in a particular column (or in a derived column created by a value expression), producing a single value that summarizes the (derived) column. The value expression argument cannot itself contain an aggregate function.
Cast	The cast functions are used to convert input values from one format to another. A cast function can appear anywhere a value expression is permitted in SQL syntax.
String	The string functions are used to manipulate character string values. A string function can be used anywhere a string value expression is permitted.
Math	The math functions are used for manipulating numeric values. A math function can appear wherever a numeric value expression is allowed.
Date/Time	The date/time functions are used to manipulate DATE, TIME, and TIMESTAMP values, and can appear wherever a value expression is permitted.
NULLIF, COALESCE, IFNULL	The three functions that are designed to handle a subset of the CASE functionality.

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

Functions Overview

Functions Overview