You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "mattcasters (via GitHub)" <gi...@apache.org> on 2026/02/18 09:35:38 UTC

[I] [Feature Request]: Dimension Lookup: new technical key types (hop)

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: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Dimension Lookup: new technical key types (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #6602: [Feature Request]: Dimension Lookup: new technical key types
URL: https://github.com/apache/hop/issues/6602


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Dimension Lookup: new technical key types (hop)

Posted by "mattcasters (via GitHub)" <gi...@apache.org>.
mattcasters commented on issue #6602:
URL: https://github.com/apache/hop/issues/6602#issuecomment-3925924300

   Also: dialog & code cleanup please


-- 
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: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org