How Do i Catch Deleted Row Source DB ??

Anonymous — Sat, 16 Nov 2024 02:21:38 GMT

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?

Re: How Do i Catch Deleted Row Source DB ??

manodwhb — Fri, 22 May 2020 07:57:37 GMT

@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.

topic How Do i Catch Deleted Row Source DB ?? in Talend Studio

How Do i Catch Deleted Row Source DB ??

Re: How Do i Catch Deleted Row Source DB ??