1 Reply Latest reply: Jul 10, 2012 4:27 AM by Stefan Wühl RSS

    Binary Load

    Joachim Glomb



      I have a question:


      I load data with the help of a binary load command. Is it possible to load just a special type
      (one selling area, couple of products, etc.) of the whole binary data model, so
      that the needed data model becomes smaller and the performance gets better.



        • Re: Binary Load
          Stefan Wühl

          I don't think that you can set constraints to the binary load directly (like a where clause in a LOAD).


          If the creation of a different source file or usage of qvd's instead of a binary load is not an option,

          I can only think of doing data model changes after the binary load, maybe using resident loads with a where clause and dropping the original tables.

          You might also consider using a Macro to select your subset of data and then reduce the data after reload.