When you configure a transformation override for an HDFS target, you can edit the mass transformations that are applied to specific source tables when they are ingested to the HDFS target.
The following image shows the transformation override that you can configure for an HDFS target:
You can edit the following properties for each target table:
Filter By. Filter the columns in the source tables.
Drop Columns. Drop columns from the source tables.
Replace Columns. Replace values in the source table columns.
Trim. Trim spaces from the beginning and end of values in source table columns.
Convert to Uppercase. Convert values in source table columns to uppercase.
Convert to Lowercase. Convert values in source table columns to lowercase.