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 the table before loading the data and running some calculations after
It is possible to run any SQL statement here,
including stored procedures
all statement must be separated by a delimiter
All our ETL tools have no limitations, which means you can load your data today and solve all the data quality problems right now.