ETL and Data Integration tools - Modern ETL software for everyone

Support

I need to delete some records from my target that were brought over from my source.
What happens is that every so often, we have records that get deleted on the source (at some point after they have been transferred by VI to my target DB) and I need to update my target by deleting this record. Is there an easy way to do this without me having to create a temp table on my target DB?

This is the only way I can do this right now but it consumes a lot of resources since I’m basically bringing
all my records from source table and then querying for unmatched records and deleting them.

Thanks,
Adam

What are the databases you are working with?

Peter

I am loading data from Foxpro into MySQL

Adam

In this case provided that you have not packed the table yet

Can you try the following lease

1 Create new ODBC Foxpro DSN.
2 Tick Deleted box for it. (Options ->deleted).
3 In Vimp use select * from table where deleted() statement as your source , It will select only deleted records.
4 Select delete records as your transformation.

Peter