When you work with databases, before performing CRUD operations, you may want to run other useful tasks, for example, verify if a database is accessible, clean up some tables before execution, and more. Look at the following sample job:
This job verifies the connectivity with a database connection. If the database is accessible, it creates a table—as soon as the table doesn't exist. After that, it executes a Transformation. If the database is not available, a message is written to the log.
Besides these, there are some ...