I am trying to automate data from 2 source DB to one destination DB where some the tables name of source DB is same but in destination DB I have given table name as soursceDBName_tableName.
QA1-> How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames ?
QA2-> Also how i can identify these tables that which data source it comes to save in right table in destination DB
Ex. subscription DB(sourceDb1) -> status(tableName)
userOrg DB(sourceDb2) -> stats(tableName)
reportDb (destinationDB) -> subscription_status(TableName), userOrg(TableName).
Please refer the screenshot for same.
I have got solution for this.
View solution in original post