Learn MD5 Function in Informatica.

This article helps you to understand MD5 function in Informatica. Let's try to understand the MD5 function and its usage in Informatica. This helps you to answer the questions related to MD5 in interviews.

What is MD5 Function?

•   MD5 is a Hash Function in Informatica.
•    It is said as Message Digest Algorithm and has many applications in cryptography.
•   It returns a 32-bit hexadecimal number which can be a-f and 0-9. It returns Null if the input is NULL.

How can we use the MD5 in practical implementation?

• When we need to load only the updated records in Target.
•  If you want to see if a particular Employee_id information updated or not.
•  It will be complex if you will compare the columns one by one. So this is the benefit to use MD5 here. It reduces the memory cache needs.
•  MD5 is used in Expression Transformation is the syntax for the function.

• It will generate the 32-bit hexadecimal number, for example, It returns A1223FGHJKJ.
• We can use lookup transformation to see if any customer information changes. And you can insert updated information directly using Update Strategy.

      Happy Learning :) Suggestions are always appreciated.