CRC32
Returns a 32-bit Cyclic Redundancy Check (CRC32) value. Use CRC32 to find data transmission errors. You can also use CRC32 if you want to verify that data stored in a file has not been modified.
If you use CRC32 to perform a redundancy check on data in ASCII mode and Unicode mode, the Data Integration Service might generate different results on the same input value. If you use CRC32 to perform a redundancy check on data on different operating systems, the Data Integration Service might generate different results on the same input value.
Syntax
CRC32( value )
The following table describes the argument for this command:
Argument | Required/ Optional | Description |
|---|
value | Required | String or Binary datatype. Passes the values you want to perform a redundancy check on. Input value is case sensitive. The case of the input value affects the return value. For example, CRC32(informatica) and CRC32 (Informatica) return different values. |
Return Value
32-bit integer value.
Example
You want to read data from a source across a wide area network. You want to make sure the data has been modified during transmission. You can compute the checksum for the data in the file and store it along with the file. When you read the source data, the Data Integration Service can use CRC32 to compute the checksum and compare it to the stored value. If the two values are the same, the data has not been modified.