2 Replies Latest reply: Jan 31, 2014 2:40 PM by Ajay Krishnan Prabhakaran RSS

    Trim data after binary load

      I am building a setup where I have Document A storing all loading and transformation of data for the company, then I do a binary load to Documents X, Y and Z all of which have very unique requirements. The reason is that anytime someone looks for sum(Sales) i want the answer to be the same so all the rule on defining what "Sales" is are in one place.


      I would like to do a binary load (Load all from Document A) then delete all the rows from the table "OrderLines" where business division not equal to X, Y or Z.


      Is this possible, or am I trying to stretch the usage of Binary load too far?