Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

CRC32

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
PowerCenter 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
PowerCenter Integration Service
might generate different results on the same input value.
CRC32 can return the same output for different input strings. If you want to generate keys in a mapping, use a Sequence Generator transformation. If you use CRC32 to generate keys in a mapping, you might receive unexpected results.

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
PowerCenter 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.