After transformations will initiate a pass of the Load table after the load has occurred. They enable manipulation of the Load table columns using the database and SQL functions.
SQL Server Example:
The following after transformation set for the column code in the table load_product
lpad(code,5,'0')
would result in the following SQL statement being executed after the load:
update load_product set code = lpad(code,5,'0');
Teradata Example:
The following after transformation set for the column code in the table load_product
substrlpad(code,1,5)
would result in the following SQL statement being executed after the load:
update load_product set code = substrcode,1,5);