MD5(Message digest function)

MD5 Algorithm and calculate checksum of enter value.
MD5 Algorithm is a commonly used in “cryptographic hash function” generating A 128-BIT (16BYTE) hash value.
MD5 also used to verify “Data Integrity”.
MD5 Returns 32 CHARACTERS STRING OF HEXADECIMAL DIGITS 0-9 AND a-f and “NULL”, if input is “NULL”

ADVANTAGE

MD5 FUNCTION is to reduce overall EXTRACT-TRANSFORM-LOAD at run time reduce cache memory usage

Step 1:

Create data Flow

step 2:

Add Expression Transformation and one attributes (md5).

step 3 :

Click on target select Data

Note : MD5 has been created using 2 columns