Answer: Derived Column

Normalizing data involves decomposing large tables into smaller, more manageable pieces and organizing the data to minimize redundancy. In Azure Data Factory, the 'Derived Column' transformation can be used to create new columns based on existing columns, which can help in the normalization process. For example, you can use the 'Derived Column' transformation to split a column into multiple columns or to create new columns based on the values in existing columns. While other transformations like 'Filter', 'Union', and 'Copy Data' have their own specific purposes, they do not directly support the normalization of data.

Author: LeetQuiz Editorial Team