Data transformation
Data transformation provides an SQL-like interface for transforming data from imported source tables. Data transformations can be used, for example, to transform data within a table, to filter data from a table, to join different source tables, etc. Data transformations are applied during data loading and are the preferred way to map source tables to the activity and enhancement tables required in the data model.