3 Replies Latest reply: Dec 3, 2014 8:54 AM by Gysbert Wassenaar RSS

    Incremental Extract on an database based on Id

      Hello,

      i met an problem i would like to implement an incremental extract based on id i loaded before in the Extract script…

       

      In fact, I’ve two table an Order Line and Order Header which are rely on an ID_Order_header.

       

      For the Order Header, there is no problem cause I ve an field  Date_Order so I can extract only the data of the day or the month anywhere…. But for the line, I don’t have a Date_Order to implement an incremental so I would like to extract the data of my line Order only for the ID_Order_header I ve extracted before..

       

      I don’t know how to do in the SQL part ?

      Is Someboby have an idea…

      Thanks