Product defined FTL templates

These FTL templates are provided by product itself.

Output of these templates can be customized with different parameters.

ATTRIBUTE_TRANSFORMATION_LIST

This FTL template uses the related entity mapping and its first source entity as the basis for the process with format:

<ftltemplate:ATTRIBUTE_TRANSFORMATION_LIST:param1=value:param2=value>

These parameters are by default supported:

• key_attribute_name

  • the attribute name used as key (currently in use with HASH_LIST transformation)

• prefix

  • the prefix wanted for the mapped source attribute fields

• target_attribute_type

  • transformation for one specific attribute type of the target entity

• transform_empty

  • the transformation to be executed to a 1-1 mapping without specified transformation

    • CAST_NAME - casts source by name to the defined target attribute data type

    • CAST_PARQUET - source attribute in parquet file casted to the defined target attribute data type

    • CAST_EXTTABLE - external table definition format

    • CAST_EXTTABLE_PARQUET - external table definition from parquet data

    • CAST_POSITION - refer to attributes by their positions instead of names (Databricks, Azure SQL Database,Azure Synapse SQL, Microsoft Fabric, Snowflake)

    • fully custom one also supported, needs project configuration

• show_target_name_bool

  • whether target attribute name should visible or not

  • default: true

SOURCE_ATTRIBUTE_NAME_LIST

This FTL template generates the mapped source entity attribute list on the defined position.

<transform:SOURCE_ATTRIBUTE_NAME_LIST:param1=value:param2=value>

These parameters are by default supported:

• position

  • the position of the source wanted source entity

• prefix

  • the prefix wanted for the mapped source entity attribute fields

• attribute_type

  • provides only the attribute name of one specific attribute type of the source entity

• indentation

  • the indentation of the result

TARGET_ATTRIBUTE_NAME_LIST

This FTL template generates the target entity attribute list.

<transform:TARGET_ATTRIBUTE_NAME_LIST:param1=value:param2=value>

These parameters are by default supported:

• prefix

  • the prefix wanted for the mapped source entity attribute fields

• attribute_type

  • provides only the attribute name of one specific attribute type of the source entity

• indentation

  • the indentation of the result

SET_TARGET_ATTRIBUTE_BY_NAME

This FTL template generates the value setting based on the target entity attribute list,
can be used in merge clauses, for example.
Mapping is done with target entity attribute names, with format:

<ftltemplate:SET_TARGET_ATTRIBUTE_BY_NAME:param1=value:param2=value>

These parameters are by default supported:

• included_attributes_list

  • the attribute name list only to be selected to the result

• included_attribute_prefix_list

  • a list of attribute prefixes those should be included

• included_attribute_type_list

  • a list of attribute types those should be included

• excluded_attributes_list

  • the attribute name list to be ignored from the result

• trg_prefix

  • the prefix wanted for the target entity

• src_prefix

  • the prefix wanted for the source entity

• indentation

  • the indentation of the result

SET_TARGET_ATTRIBUTE_BY_TRANSFORMATION

This FTL template generates the value setting based on the target entity attribute list, can be used in merge clauses, for example.
Mapping is done with target entity attribute transformation formula, with format:

<ftltemplate:SET_TARGET_ATTRIBUTE_BY_TRANSFORMATION:param1=value:param2=value>

These target attribute transformations are supported:

• DELETE_TS

• DEACTIVATE_TS

• DV_STATUS

• SET_ACTIVE_STATUS

These parameters are by default supported:

• included_attributes_list

  • the attribute name list to be handled from the result

• excluded_attributes_list

  • the attribute name list to be skipped from the result

• included_attribute_prefix_list

  • a list of attribute prefixes those should be included

• included_attribute_type_list

  • a list of attribute types those should be included

• override_prefix_transformation_map

  • a map of attribute prefixes and the transformation to be utilised for them

• override_attribute_type_transformation_map

  • a map of attribute types and the transformation to be utilised for them

• prefix

  • the prefix wanted for the source entity

• show_target_name

  • indicates whether the name of the field should be shown

• indentation

  • the indentation of the result