Test Data Manager

 View Only
Expand all | Collapse all

Datamaker - Publish data from subset and checking existence of keys

  • 1.  Datamaker - Publish data from subset and checking existence of keys

    Posted Dec 12, 2017 08:09 AM

    Hello,

     

    I need to publish a subset (on a Sybase ASE environment...).

    Normaly, i use a "truncate" action on the target table, before publishing to avoid trouble on duplicate keys...

    But, on a new case; i can´t delete the data on target table, because it´s a domain table that other systems look at.

    How can i just insert the new data from source, avoiding the usual "delete and insert" actions?

    Is there any way to do that?

     

    Thx



  • 2.  Re: Datamaker - Publish data from subset and checking existence of keys
    Best Answer

    Broadcom Employee
    Posted Dec 12, 2017 12:26 PM

    While publishing the data, you can select the option on what you want to do if you encounter duplicates in the data target, you can choose to update the value if it already exists or just continue without updating.

     

     

    Thanks,

    Anil



  • 3.  Re: Datamaker - Publish data from subset and checking existence of keys

    Posted Dec 12, 2017 12:34 PM

    Thx Anil;

     

    I will try that!!!