Customer Portal

Insert/update in DBOutput

Comments 2

  • Avatar
    slechtaj
    0
    Comment actions Permalink
    Hi,

    You are right. The thread you mentioned in your post deals with the UPSERT operation. The idea is to read the source data from one table and join them with data in target table. As you can see in our online documentation (http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/dbjoin.html), data are joined and sent to output ports accordingly:


    • matched records are sent to output port 0

    • unmatched records are sent to output port 1.



    In DBJoin you need to set up the SQL query with WHERE clausule (the key is represented by question mark). You will also need to set up transformation (you can adjust input records as you wish) – this will drive the data sent to output ports.
    For more information see attached sample (you will need to change the design according to your scenario).
  • Avatar
    jericotolentino
    0
    Comment actions Permalink
    I based my modifications on the attached example. Working as expected now. Thanks!

Please sign in to leave a comment.