Kettle control addachecksum

Thisstepcalculateschecksumsforoneormorefieldsintheinputstreamandaddsthistotheoutputasanewfield. Calculate the verification code for the columns input by the data stream and use the output as a new column. Wiki: wiki. pentaho. comdisplayEAIAdd + a + checksumOption

This step calculates checksums for one or more fields in the input stream and adds this to the output as a new field. calculate the verification code for the column entered by the data stream and use the output as a new column. Introduction In wiki: http://wiki.pentaho.com/display/EAI/Add+a+checksum Option

This step calculates checksums for one or more fields in the input stream and adds this to the output as a new field.

Calculate the verification code for the column entered by the data stream and use the output as a new column.

Introduction In wiki: http://wiki.pentaho.com/display/EAI/Add+a+checksum

Option	Description
Step name	Name of the step.Note: This name has to be unique in a single transformation.
Type	The type of checksum that needs to be calculated. These are the types that are available: CRC32: 32-bit Cyclic Redundancy Check: http://en.wikipedia.org/wiki/Cyclic_redundancy_check ADLER 32: Checksum algorithm by Mark Adler: http://en.wikipedia.org/wiki/Adler-32 MD5: Message Digest algorithm 5: http://en.wikipedia.org/wiki/MD5 SHA-1: Secure Hash Algorithm 1: http://en.wikipedia.org/wiki/SHA-1
Result field	The name of the result field containing the checksum
Fields used in the checksum	The names of the fields to include in the checksum calculation. Note: You can use the "Get Fields" button to insert all input fields from previous steps.

Note: After double-clicking the control, you can see various settings. The result field must be the name of the new column.

At this time, the compatibility mode option is displayed. After the check, the field will become compact and may not be long. The default value is not selected. It is a 32-bit long field!

I use a fixed length to compare fields.

If you want to know the difference, perform the test:

Then the preview rows shows the differences between the two results.