What would you like to happen?
The Checksum transform simply concatenates the String contents of all specified fields before calculating the specified checksum.
To facilitate specific use-cases in database modeling like Data Vault 2.0, we want a few extra options:
- A separator string (used to separate the strings from the fields)
- A prefix String
- A suffix String
The separator helps generate more unique hash codes.
These prefix/suffix options can help keep hash keys from different topics, for example customer_id=123 and product_id=123 would result in the same hash key. If we could add a prefix or suffix PROD and CUST, we don't have the same problem.
Issue Priority
Priority: 3
Issue Component
Component: Transforms
What would you like to happen?
The Checksum transform simply concatenates the String contents of all specified fields before calculating the specified checksum.
To facilitate specific use-cases in database modeling like Data Vault 2.0, we want a few extra options:
The separator helps generate more unique hash codes.
These prefix/suffix options can help keep hash keys from different topics, for example customer_id=123 and product_id=123 would result in the same hash key. If we could add a prefix or suffix PROD and CUST, we don't have the same problem.
Issue Priority
Priority: 3
Issue Component
Component: Transforms