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

[#1]

Hi ,

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.

[#2 · Accepted solution]

I have got solution for this.