How Do i Catch Deleted Row Source DB ??

[Anonymous]

SourceDB : ERP_Prod

TargetDB  : ERP_Dev

[ Problem ]

every night, migration sourceDB to targetDB (to Motivate)

but, if sourceDB A table row is deleted. (ex. row : sale_num : 20200427 ... ~~~ ... )

targetDB A table is still remain row (sale_num : 20200427 ~~~ )

[ Desire ]

if deleted row from sourceDB then also targetDB row deleted.

[ Solution(my) ]

before migration, drop table and then etl job.

but this solution is so heavy and take a long time.

can i get solution?

[manodwhb · Accepted solution]

@Moe , Take target table as a main and Source table as lookup and do inner join on key column and take inner join rejects in tmap and then load into a temp table and delete the records based temp table to target table.