Overwriting data on import

  • Posts: 22
  • Thank you received: 0

Overwriting data on import was created by Dave

Hi,

I have been using the VIMP software to import from my odbc DB to a mysql and it work fine to the point where it populates the data when the target table is empty, but i want to be able to import a fresh instance of data at every scheduled refresh over existing data. The new data does not overwrite the data in the existing db target.

Help please.

Many thanks

Dave
10 years 6 months ago #2521

Please Log in or Create an account to join the conversation.

  • Posts: 8292
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Re: Overwriting data on import

You need to specify update key and set data transformation type to

Add new update existing records

Mike
Mike
ETL Architect
10 years 6 months ago #2522
Attachments:

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies