[Informatica] Generate Random Password in Informatica

[How To] Generate Random Password in Informatica

The below tutorial explains how one can use Informatica to generate random password each time the workflow is run.

Approach:
We will be using the inbuilt RAND() function to first generate random number between 0 and 1. Further we convert this to an alpha-numeric value by calculating the MD5 hash checksum of this value.
Using this approach there is no way you decrypt or crack the password as the password generation is not based on the username or any other static combination.

md5(TO_CHAR(RAND()))

You can further use SUBSTR() to reduce the length of the password.

Implementation:
Mapping:
Mapping - Vishal Lambe
Expression: 
Expression To generate Passwords - Vishal Lambe

Output File: