Project Simulation

You can run an ETL project in simulation mode to monitor and validate your transformation process at every step.

Note: If you are running an ETL project in simulation mode and your objective is to test transformation rules, you may want to use a test data target.

In contrast to executing a project, simulation allows you to:

Run projects that have unsaved changes.
Monitor and validate the transformation process step by step. Data flow is visible on any link and within any component included. You can also inspect any component, and modify mappings and calculations.

After making changes, you can reinitialize the component with the new settings and step to the next component without restarting the simulation.

During the final steps of a simulation, data is either written into the data sinks, or rolled back, depending on your selection. Many transformation components, such as the Data Calculator, allow you to change transformation rules and sample values during simulation, to validate your rule base for all potential content.

Note:

You can simulate a project only after all components have been properly initialized.