Analyze your transformation results
You can see how your transformation performed, if errors occured, and explore the data by viewing the execution results.
After you Run your transformation, the Execution Results panel appears. It contains several different tabs that help you to see how the transformation ran, pinpoint errors, monitor performance, and further inspect the data.
The Step Metrics tab shows statistics for each step in your transformation including how many records were read, written, caused an error, processing speed (rows per second) and more. This tab also indicates whether an error occurred in your transformation step. If a mistake had occurred, steps that caused the transformation to fail will be highlighted in red. In the example below, the Lookup Missing Zips step caused an error.
The Logging tab displays the logging details for the most recent execution of the transformation. You can also drill in deeper to determine where errors occur. Error lines are highlighted in red. In the example below, the Lookup Missing Zips step caused an error because it attempted to lookup values on a field called POSTALCODE2, which did not exist in the lookup stream.
The Execution History tab enables access to the Step Metrics and Logging information from previous executions of your transformation. This history only works if you have configured your transformation to log to a database through the Logging tab of the Transformation Settings dialog box. For more information on configuring logging, see Logging and performance monitoring.
The Performance Graph enables you to analyze the performance of steps based on a variety of metrics including how many records were read, written, caused an error, processing speed (rows per second) and more. Like the Execution History, this graph requires you to configure your transformation to log to a database through the Logging tab of the Transformation Settings dialog box.
The Metrics tab shows a Gantt chart after your transformation executes. It contains information such as how long it takes to connect to a database, how much time is spent executing a SQL query, or how long it takes to load a transformation.
The Preview Data tab displays a preview of the data per each step. Click on a step to show the data values for that step.
The Inspect Data button opens a data exploration interface to inspect the data of a step. The interface allows you to visually analyze a subset of your data values at a selected step. You can also access this interface through the Inspect Data and Run and Inspect Data options in the fly-out inspection bar, which appears when you click on a step.
For information about the interface, see Inspect your data.