Data Mappings

Transformation types

  • SET-NULL: Transforms any input to NULL
  • HASH: Transforms string input to hash
  • HASH-SKIP-FIRST-n: Transforms string input to hash skipping first n characters, e.g. HASH-SKIP-FIRST-2
  • MASK-DATE: Replaces the months and day parts of date columns to be always 1st of Jan
  • MASK-NUMBER: Transforms any numeric value to zero
  • MASK-HIDDEN: Transforms any string to ‘hidden’
  • MASK-STRING-SKIP-ENDS-n: Transforms string input to masked version skipping first and last n characters, e.g. MASK-STRING-SKIP-ENDS-3