Table of Contents


  1. Preface
  2. Part 1: Version 10.2.2
  3. Part 2: Version 10.2.1
  4. Part 3: Version 10.2
  5. Part 4: Version 10.1.1
  6. Part 5: Version 10.1

Data Preparation Operations

Data Preparation Operations

Effective in version 10.2.1, you can perform the following operations during data preparation:
Pivot Data
You can use the pivot operation to reshape the data in selected columns in a worksheet into a summarized format. The pivot operation enables you to group and aggregate data for analysis, such as summarizing the average price of single family homes sold in each city for the first six months of the year.
Unpivot Data
You can use the unpivot operation to transform columns in a worksheet into rows containing the column data in key value format. The unpivot operation is useful when you want to aggregate data in a worksheet into rows based on keys and corresponding values.
Apply One Hot Encoding
You can use the one hot encoding operation to determine the existence of a string value in a selected column within each row in a worksheet. You might use the one hot encoding operation to convert categorical values in a worksheet to numeric values required by machine learning algorithms.
For more information, see the "Prepare Data" chapter in the
Informatica 10.2.1 Enterprise Data Lake User Guide

Updated July 27, 2020