Scribd
Upload
779 views3 pages

Informatica Function CheatSheet

This document is a cheat sheet for Informatica PowerCenter functions, categorized into string, numeric, date, conversion, conditional, and aggregate functions. Each function is presented with an example output or description, illustrating its usage. It serves as a quick reference for users to understand and apply various functions in Informatica PowerCenter.

Uploaded by

rimaghosh6299
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
779 views3 pages

Informatica Function CheatSheet

This document is a cheat sheet for Informatica PowerCenter functions, categorized into string, numeric, date, conversion, conditional, and aggregate functions. Each function is presented with an example output or description, illustrating its usage. It serves as a quick reference for users to understand and apply various functions in Informatica PowerCenter.

Uploaded by

rimaghosh6299
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Informatica PowerCenter Function

Cheat Sheet
String Functions
Function Example Output / Description

UPPER('abc') ABC

LOWER('ABC') abc

INITCAP('hello world') Hello World

LTRIM(' space') space

SUBSTR('abcdef', 2, 3) bcd

INSTR('abcdef', 'cd') 3

REPLACE('abcabc', 'a', 'x') xbcxbc

CONCAT('abc', '123') abc123

Numeric Functions
Function Example Output / Description

ROUND(123.456, 2) 123.46

TRUNC(123.456, 2) 123.45

ABS(-10) 10

MOD(10, 3) 1

CEIL(4.2) 5

FLOOR(4.8) 4

POWER(2, 3) 8

SIGN(-5) -1
Date Functions
Function Example Output / Description

SYSDATE Current system date

TO_DATE('2024-01-01', 'YYYY-MM-DD') 01-Jan-2024

TO_CHAR(SYSDATE, 'YYYY') 2025

ADD_TO_DATE(SYSDATE, 'MM', 1) Next month date

MONTHS_BETWEEN('2025-04-01', '2025- 3
01-01')

Conversion Functions
Function Example Output / Description

TO_INTEGER('123') 123

TO_FLOAT('123.45') 123.45

TO_DECIMAL('123.456') 123.456

TO_CHAR(123) '123'

TO_DATE('2025-04-01', 'YYYY-MM-DD') 01-Apr-2025

Conditional Functions
Function Example Output / Description

IIF(1=1, 'Yes', 'No') Yes

DECODE(2, 1, 'One', 2, 'Two', 'Other') Two

NVL(NULL, 'default') default

ISNULL(NULL) TRUE

Aggregate Functions
Function Example Output / Description

SUM(SALARY) Sum of all salaries


AVG(SALARY) Average salary

MAX(SALARY) Highest salary

COUNT(EMP_ID) Number of employees

You might also like