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?

       

      Thanks!