Data Integration Connectors
- Data Integration Connectors
- All Products
Functions
| SQL ELT optimization Type
|
---|---|
ABS()
| Source, Full
|
ADD_TO_DATE()
| Full
|
ASCII()
1
| Full
|
AVG()
| Source, Full
|
CEIL()
1
| Full
|
CHR()
| Full
|
CONCAT()
1
| Full
|
COS()
| Source, Full
|
COSH()
| Full
|
COUNT()
| Source, Full
|
DATE_COMPARE()
| Source, Full
|
DATE_DIFF() 2
| Full
|
DECODE()
| Source, Full
|
EXP()
| Source, Full
|
FIRST()
| Full
|
FLOOR()
1
| Full
|
GET_DATE_PART()
| Full
|
IIF()
| Source, Full
|
IN()
| Source, Full
|
INSTR()
| Full
|
IS_DATE() 2
| Full
|
IS_NUMBER() 2
| Full
|
ISNULL()
| Source, Full
|
LAST_DAY() 2
| Full
|
LENGTH()
1
| Full
|
LN()
| Full
|
LOG()
| Full
|
LOWER()
| Source, Full
|
LPAD() 2
| Full
|
LTRIM()
1
| Full
|
MAX()
| Source, Full
|
MIN()
| Source, Full
|
MD5()
2
| Source, Full
|
MOD()
1
| Full
|
POWER()
| Source, Full
|
REPLACECHR() 2
| Full
|
REPLACESTR() 2
| Full
|
ROUND(NUMBER)
| Full
|
RTRIM()
1
| Full
|
SIGN()
| Full
|
SIN()
| Source, Full
|
SINH()
| Full
|
SOUNDEX()
| Full
|
SQRT()
| Source, Full
|
STDDEV()
| Full
|
SUBSTR()
| Full
|
SUM()
| Source, Full
|
SYSTIMESTAMP()
1
| Full
|
TAN()
| Source, Full
|
TANH()
| Full
|
TO_BIGINT
| Full
|
TO_CHAR(DATE)
1
| Full
|
TO_CHAR(NUMBER)
1
| Full
|
TO_DATE()
| Full
|
TO_DECIMAL()
| Full
|
TO_FLOAT()
| Full
|
TO_INTEGER()
| Full
|
TO_NUMBER()
| Full
|
TRUNC(NUMBER)
| Full
|
UPPER()
| Source, Full
|
VARIANCE()
| Full
|
1 Applies also in Expression transformations for mappings enabled with source
SQL ELT optimization .
2 Applies only in an Expression transformation.
|