Lookup
Lookup transformation function substitutes values using mapping table. The mapping table can be populated manually or loaded from file/database
Lookup Replace
Lookup Replace transformation function replaces keys with values
Range Lookup
Range Lookup transformation function finds a key for a given range
SQL Lookup
SQL Lookup transformation function retrieves values from the database using SQL. Parameters are replaced with actual values before the execution