mattcasters opened a new issue, #6602: URL: https://github.com/apache/hop/issues/6602
### What would you like to happen? It would be nice to have a few new types of technical key generation in the Dimension Lookup/Update transform: * A UUID: generate a new UUID which we consider unique (String) * An existing String field * An existing Binary field For the existing fields: these values can come from EDW systems like Data Vault. It should also be possible to construct a hash key based off an existing field. Usually that field can be constructed by concatenating the natural key and the update timestamp. This can simply be done with the "Add a checksum" transform. What works is calculating an MD5 over a business key along with the update timestamp. The String hash key is simply the Hexadecimal form of the Binary MD5. (16 bytes or 32 characters) ### Issue Priority Priority: 3 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
