Customer Portal

MongoDB look up of Json

Comments 1

  • Avatar
    imriskal
    0
    Comment actions Permalink
    Hi Micky,

    I think DataIntersection is the component you seek, see http://doc.cloveretl.com/documentation/ ... ction.html

    Based on specified key fields, you can compare records from two sources and react in three ways. For instance:
    A) If the record is in your json input file and does not exist in DB, you can insert it.
    B) If the record exists in both sources, you can update it in DB.
    C) If the record exists in DB and does not exist in the json file, you can delete it or skip it.

    Regards,

Please sign in to leave a comment.