Custom FTL TEMPLATES in Entity Load Steps

Load steps currently support customizable FTL templates with few approaches:

• Product defined transformations

• Product defined templates

• User defined templates

Product defined transformations

Product defined transformations are callable with normal <variable> - syntax.

• target_entity_attribute_list_with_transform

• target_entity_attribute_list_with_transform_cast_and_positions

• target_entity_attribute_list_with_transform_cast_and_names

• target_entity_attribute_list_with_transform_cast_exttable

• target_entity_attribute_list_with_transform_cast_exttable_parquet

• target_entity_attribute_list_with_transform_cast_parquet

Product defined FTL templates

Product provides predefined templates which can be directly used. See

Product defined FTL templates

User defined FTL templates

Any FTL template defined in CONFIG_LOAD_TEMPLATES package for a specific DBMS product can be called as user defined FTL template in entity load step with format (example MY_TRANSFORMATION):

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

The transformation engine uses Freemarker Template Engine

Freemarker version in use is 2.3.33

Helper functions and macros

There are multiple functions and macros those can be utilised within the FTL templates directly. See Supported FTL functions and macros

Available template model

Examples

Target database name: model.targetDbName

Target load name: model.load.name

Target entity: model.load.target

Target entity attributes: model.load.target.attributes

All source entities: model.load.sources