You can run projects using either simulation or execution mode.
Both modes perform all functions of the components included in a project, including the physical transfer of data into the data targets or data sinks.
Simulation mode enables you to:
Run projects with 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. You do not have to start the simulation from the very beginning of the project after any of the components have been changed.
You can simulate your projects interactively or non interactively. Either way, data is written into the data sinks at the end of simulation. See “Simulating projects interactively” and “Simulating projects noninteractively” for details.
If you are running a project in simulation mode and your objective is to test the transformation rules, you may want to use a test data target.
Execution mode enables you to:
Run projects and jobs that have been saved to the repository. Unsaved changes are not executed.
Directly execute the project and reflect the changes in the data sink. You cannot monitor the transformation process step by step.
You can execute projects and jobs either from Sybase ETL Development, or as a scheduled task. See “Managing jobs and scheduled tasks”.