Script Checksum Transformation

Overview

Transformation data flow component, which calculates CRC32 checksum or SHA-256 hash for one or more input columns.

Setup

The script has the following parameter:

• Algorithm - the checksum algorithm - CRC32 or SHA-256.
• IsInputColumnsVariable - Indicates whether a variable contains the input columns.
  • InputColumns - input columns for checksum.
  • InputColumnsVariable - variable containing the input columns.
• ResultAsNumeric - defines if the CRC32 result is numeric or hex string.
• ResultAsBytes - defines if the SHA-256 result is bytes or hex string.
• Delimiter - defines the multiple columns delimiter.