CONFIG_LOAD_TRANSFORMATIONS

"attrTransformationTypes": [
  ...
  {
    "transformationType": "HASH",
    "isShownInDesigner": true,
    "ordinalPositionInDesigner": 2
  }
  ...
]

"dbmsTransformationFormulas": [
  ...
  {
    "transformationType": "MODIFIED_HASH_FOR_RS",
    "dbmsProduct": "REDSHIFT",
    "transformationFormula": "MD5(UPPER(<#list sourceAttributes as attribute>\n<#if attribute.datatype?? && attribute.datatype?lower_case?contains(\"char\")>\nNVL(${attribute.attributeName}, '-1')\n<#elseif attribute.datatype?? && attribute.datatype?lower_case?contains(\"bool\")>\nNVL(CAST(CAST(${attribute.attributeName} AS INT) AS VARCHAR), '-1')\n<#else>\nNVL(CAST(${attribute.attributeName} AS VARCHAR), '-1')\n</#if>\n<#if attribute_has_next> || '#' || </#if></#list>))"
  }
  ...
]

  "attrTransformationTypes": [
      {
      "transformationType": "CUSTOM_HUB",
      "shortDescription": "Transformation for Hub",
      "description": "Transformation formula to be used for Hub-entities. Target field should be BINARY(16).",
      "isShownInDesigner": true,
      "ordinalPositionInDesigner": 14
    }
  ],
  "dbmsTransformationFormulas": [
    {
      "transformationType": "CUSTOM_HUB",
      "dbmsProduct": "SNOWFLAKE",
      "transformationFormula": "NVL(MD5_BINARY(UPPER(<#list sourceAttributes as attribute>TRIM(${attribute.attributeName}::STRING)<#if attribute_has_next> || '~' ||</#if></#list>)), '00'::BINARY)"
    }
  ]

  "attrTransformationTypes": [
      {
      "transformationType": "HASH_LIST_SHA2",
      "shortDescription": "Hash list with SHA2",
      "description": "Transformation formula with SHA2 hashing",
      "isShownInDesigner": true,
      "ordinalPositionInDesigner": 17
    }
  ],
  "dbmsTransformationFormulas": [
    {
      "transformationType": "HASH_LIST_SHA2",
      "dbmsProduct": "MS_SQL",
      "transformationFormula": "<#macro castClouse attribute prefix=\"\">    <#if attribute.datatype?? && ( attribute.datatype?lower_case?contains(\"nvarchar\") || attribute.datatype?lower_case?contains(\"nchar\") )>      TRIM(COALESCE(CAST(${prefix}[${attribute.attributeName}] AS VARCHAR(MAX)), '-1'))    <#elseif attribute.datatype?? && attribute.datatype?lower_case?contains(\"char\")>     TRIM(COALESCE(${prefix}[${attribute.attributeName}], '-1'))    <#elseif attribute.datatype?? && attribute.datatype?lower_case?contains(\"geo\")>      COALESCE(CAST(${prefix}[${attribute.attributeName}].STAsText() AS VARCHAR(MAX)), '-1')    <#elseif attribute.datatype?? && attribute.datatype?lower_case?contains(\"bool\")>      COALESCE(CAST(CAST(${prefix}[${attribute.attributeName}] AS INT) AS VARCHAR), '-1')    <#else>      COALESCE(CAST(${prefix}[${attribute.attributeName}] AS VARCHAR), '-1')    </#if></#macro><#macro sourceAttributeList sourceAttributes prefix=\"\">    <#if sourceAttributes?size == 0 >        null    <#else>        <#list sourceAttributes as attribute><@castClouse attribute prefix/><#if attribute_has_next> + '~' + </#if></#list>    </#if></#macro> ( SELECT CONVERT(VARCHAR(32),HASHBYTES('SHA2_256',   STRING_AGG(<@sourceAttributeList sourceAttributes/>)  WITHIN GROUP (    ORDER BY <@sourceAttributeList sourceAttributes/>   ) ),2) FROM [${sourceEntity.owner}].[${sourceEntity.entityName}] value_list WHERE<#if useBatchLoading>    <#if sourceEntity.containsRunIdAttribute>        value_list.[${sourceEntity.runIdAttributeName}] IN (<loadablerunids>)    <#else>        value_list.<sourcerunidattr> IN (<loadablerunids>)     </#if></#if><#if loadOptDefined(\"OPT_WHERE\")><#if useBatchLoading>AND </#if>${loadOpt(\"OPT_WHERE\")}</#if><#list keyAttributeList as keyAttribute>    <#if useBatchLoading || loadOptDefined(\"OPT_WHERE\")>AND </#if>     <@castClouse keyAttribute \"value_list.\"/>=<@castClouse keyAttribute \"src_entity.\"/></#list>)"
    }
  ]