Tag: MySQL
-
Reconciliation between source and target tables
MySQL INFORMATION_SCHEMA database offers useful statistics for basic data reconciliation. PDI transformation to check data between source and target tables
-
Move data from MySQL to Google Cloud MySQL
Suppose you have a MySQL database running on a hosted VM or local environment. You need to copy data from each table to Google Cloud MySQL. Some of the tables are quite large. Here are the few steps you need to consider: Pre-Requisites Connection to Source & Target – JDBC driver & connection settings User…