By definition checksum is a way to determine the integrity of data in which both the sender and receiver can test the data integrity weather it is correct or not, the sender calculates the checksum value by taking the sum of binary data transmitted on the other end the receiver can perform the same calculation on the data and compare it with the checksum value provided by the sender. If the two values match, the receiver has surety that the data was received correctly.
Pentaho Spoon provide the Add a Checksum Step lying under the Transformation Tab.
- Go to Design
- Drill Down Transformation
-
Drag & Drop Add a Checksum -
-
Name the Step -
Define the Checksum Algorithm most used Algorithm for Checksum is MD-5 -
Click the Get Fields Button, this will extract and show all the fields coming from the previous step at which your going to apply checksum might be extracting using Input Step from the database table or Stored Procedure
0 comments:
Post a Comment