LPad - Left padding in Informatica

The LPAD function adds a set of blanks (Empty Spaces) or characters to the beginning of a string, and makes the string to uniform Length

General Syntax
LPAD (first_string, length [, second_string])

When the second argument is omitted, Informatica Pads with Spaces.

Example : Pads Marks With 0's and the length of the string is always uniform
LPAD (Marks, 3, '0')

MarksReturn Value