In ETL, the process of splitting a single data column into multiple columns is referred to as ________ transformation.

  • Decompose
  • Split
  • Unpack
  • Unpivot
The correct term is "Unpivot" transformation. This involves breaking down a single column with multiple values into separate columns, each representing a specific attribute. It is useful for organizing and structuring data for analysis.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *