If your target is a SQL, PostgreSQL, or MySQL server, the properties panel will display an option called 'Execute Script After Completion.'
- This option allows you to execute an SQL script after the ETL is run
- Separate each statement with a semicolon and start each statement in a new line
In the example below, two statements are entered to create two clustered indexes; one for Manufacturers and manfKey, and another for Manufacturer Details and Manufacturer:
You can enable or disable the ability to execute a script after completion by checking or unchecking the 'Create post scripts (sql target)' option (red arrow below) from the Admin console, in the Profiles panel under Access.