Visual Importer ETL is capable of running SQL before and after loading data into the target database.
Note:
- SQL is executed against the target database
- All SQL statements must be separated by a delimiter
- it is possible to run any sql statement including executions stored procedures
Typical usage of this feature would be truncating table before loading the data and running some calculations after
All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.
