I have requirement where in I pull say for example 1 million Revenue record from upstream system and push the
raw data in to staging and from staging push 75000 revenue records in to CRM 2013 online Data base. I have various filter criteria
in CRM like Area,fiscal period. Once I apply those filters in CRM and click retrieve. it should just fetch the revenue nos
and not the actual records.what is the best method in terms of performance to retrive data from CRM online DB. Regards, Vino