Skip to content

[Feature Request]: Dimension Lookup: new technical key types #6602

@mattcasters

Description

@mattcasters

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

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions