ltrim on decimals in informatica
ABORT - Stop the session and report error
China Gas Boiler
ABS - Return absolute numeric value
Toppo Lighting Company Limited
ADD_TO_DATE - Add or Subract Days, Months, Years to Existing Date
Add months in Informatica
AES_DECRYPT - Decrypt AES encrypted data
AES_ENCRYPT - Encrypt data using AES encryption standards
ASCII - Find ASCII value of a character
CHRCODE - Find ASCII value of a character
AVG - To find average of all rows
Ceil
CHOOSE - Choose a string from a list of strings
CHR - Character equivalent of ASCII Number
Escape single quote or How to print single quote
Comment Line
COMPRESS - Compress string value
DECOMPRESS - Decompress a compressed string
Concatenation Operator - ||
CONCAT - Join two strings
CONVERT_BASE - Change numeric value base from one to another
Converting date from one format to other
COS - Find cosine value
COSH - Find hyperbolic cosine
COUNT - Number of rows with not null values
CRC32 - Find cyclic redundancy check value
CUME - Find cumulative total
Date Format
TO_CHAR Date Format
TO_DATE and IS_DATE Formats
Date_Compare - Compare Two Dates
DATE_DIFF - Find Time Interval between two dates in Year, Months or Days or in Hours
DEC_BASE64 - Decode a base 64 encoded value
ENC_BASE64 - Encode binary data
DECIMAL conversion problem
Decode - Value Search or Nested If Else
Error - Throw an Error
EXP - Raise e to specified power
Find empty string in informatica
Find Odd or Even in Informatica
First - Returns first value of a port or group
Floor - Integer less than or equal to current number
FV - Find future value of an investment
GET_DATE_PART - Extract days or month or year date part from the date
GREATEST - Find greatest value
IIF - Conditional Statement
Nested If
IN - Find a value in list of values
IndexOf - Index of value in a list of values
INITCAP - Capitalize each word in a string
INSTR - Search for a String
INSTR - More Examples
Search for single quote
IS_DATE - Check for Valid Date
IS_NUMBER - Check for Valid Number
IS_SPACES - Check for all Spaces
ISNULL - Check if a value is null
Not NULL check
Last - Find last row in selected port
LAST_DAY - Get date of the last day of the month
Least - Find smallest value from the list of values
Length - Find Length of the String
LN - Find natural logarithm of a numerical value
Log - Find logarithm of numeric value
Lower - Convert a string to lower case
LPad - Left padding
MAKE_DATE_TIME - Returns date based on given inputs
MAX - Find maximum value of number or date or string port
MD5 - Returns MD5 checksum
Median - Find median of all values
MIN - Find minimum value of number or date or string port
MIN - Find minimum value of number or date port
MOD - Find remainder of division
RAND - Generate a Random Number
Get N digit random number
REG_EXTRACT - To extract specified pattern using regular expressions
REG_EXTRACT - Extract a Number From String
REG_EXTRACT - Extract a Date From String
REG_MATCH - Check string matches a specified regular expression - Syntax and Usage
REG_MATCH - String starts with check
REG_MATCH - String ends with check
REG_MATCH - String contains or like operation
REG_REPLACE - Replace a string matched by regular expression pattern
Remove Time Component From Date Time
REPLACECHR - Replace characters in a string with some other character or remove them
REPLACESTR - Replace a string with another string
REPLACESTR - Replace or Remove a single quote character
Reverse - Reverse a string
Round - Rounds one part of the date
RPad - Right Padding
SET_DATE_PART - Change date or month or year part in DateTime
String to date conversion :
Substr - To Find Substring
Test
To_Char - Convert Integer or Date to String
To_Date - Convert String to Date
To_Decimal - Convert To Decimal
To_Integer - Convert a String To Integer
Trim
RTrim - Right Trim
LTrim - Left Trim
TRUNC - Truncate Day or month or year part in DateTime
Upper - Convert a string to upper case
UPSERT - Update else Insert