Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is checksum terminology in informatica? Where do you use it ?




1266
views
asked marvit September 20, 2014 08:05 AM  

What is checksum terminology in informatica? Where do you use it ?


           

1 Answers



 
answered By Mswami   0  
A checksum is a value used to verify the integrity of a file or a data. Checksums are typically used to compare two sets of data to make sure they are the same. If the checksums don't match those of the original file or data, the data may have been altered.

Informatica provides the function MD5() for Checksum generation. This function returns a unique 32-character string of hexadecimal digits 0-9 and a-f.

Syntax : MD5( value )
Return : Unique 32-character string of hexadecimal digits 0-9 and a-f.

Checksum used to cretae unique columns in table when you implement checksum on any field in table during load time then it will automatically find the max value of the field and add 1 for every next record inserted. Basically used in SCD to create Index. 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert