What’s a “insert or update” and “update or insert”, how do we find the difference?

devquora
devquora

Posted On: Feb 22, 2018

 

  • First, insert or update: In this action, firstly Talend tries to insert a record. However, if a record is with an identical primary key that already exists, then only it updates that record.
  • On the contrary, update or insert is where the action changes, Talend first tries to update a record with an identical primary key. However, if there's none, then the record is inserted.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Talend Interview Questions

    What do you understand by Talend in general?

    Talend is a simple open source software integration platform/vendor which offers integration and data..

    Talend Interview Questions

    Why Talend when there are many other ETL tools available?

    Following is the major advantage of Talend: Talend operates with a huge community in a very little expense in a very swift..

    Talend Interview Questions

    What do you know about connections in Talend?

    In Talend, connections are the ones to determines the data process, data output, or the logical sequence of work..