Working with transformations

Create, configure, and then run transformations to perform ETL tasks as part of specified workflow. After running a transformation, analyze its results to explore the data or to identify possible improvements or problems.

Note: You can schedule a transformation to run a single time or on a recurring schedule. For details, see

• Create a transformation

  Create a transformation to arrange a network of logical ETL tasks, called steps, into a data workflow.

• Edit transformation properties

  Transformation properties describe the transformation and configure its behavior. You can use transformation properties to customize the processing of your data to achieve the desired output.

• Run a transformation

  Run a transformation to step through the ETL tasks you set up, in the order specified by the transformation.

• Analyze transformation results

  You can see if errors occurred, explore the data, and review how your transformation performed, by viewing logs, previewing data, and reviewing step metrics.

• Transformation steps in Pipeline Designer

  Steps extend and expand the functionality of transformations. You can use the following steps in Pipeline Designer.