MySQL scenarios
- Checking customer table against a given DQ rule to select customer records
- Combining two flows for selective output
- Controlling the data definition language via tMysqlOutput when creating a table
- Getting the ID for the last inserted record with tMysqlLastInsertId
- Inserting a column and altering data using tMysqlOutput
- Inserting data in bulk in MySQL database
- Inserting data in mother/daughter tables
- Inserting transformed data in MySQL database
- Iterating on DB tables and deleting their content using a user-defined SQL template
- Iterating on a DB table and listing its column names
- Populating a MySQL data warehouse
- Reading email addresses from a DB table and retrieving specific data
- Removing and regenerating a MySQL table index
- Retrieving data in error with a Reject link
- Sharing a database connection between a parent Job and child Job
- Updating a database table using tMysqlOutput in a Big Data Streaming Job
- Updating data using tMysqlOutput
- Using PreparedStatement objects to query data
- Using tMysqlSP to find a State Label using a stored procedure
- Writing columns from a MySQL database to an output file using tMysqlInput
- Writing dynamic columns from a source file to a database