The Metadata tab contains the following variables that you can use in an expression:
- AR_M_SOURCE_SCHEMA - The name of the source schema.
- AR_M_SOURCE_TABLE_NAME - The name of the source table.
- AR_M_SOURCE_COLUMN_NAME - The name of a column in the source table.
- AR_M_SOURCE_COLUMN_DATATYPE - The data type of a column in the source table.
For example, to rename all columns named "metadata" to "source_schema.table_name", enter "metadata" in the Column name is like field (in the What to transform? screen) and then enter the following expression in the Rename column to field (in the How to transform? screen):
$AR_M_SOURCE_SCHEMA ||"."|| $AR_M_SOURCE_TABLE_NAME