Left Join (ItemByMasterDate) LOAD * Resident ItemEntries;
DROP Table ItemEntries; //no synth. keys
Is there something wrong or are over 3 Million Entries in ItemEntries for this loads of MasterDates really too much, even for a big server?
I'm trying to do this: Sum up until dimension value . In my "old" solution it lasts some minutes... Therefore I'd like to use a Flag like tresesco suggested.
Or does someone has a idea for a good performance?
Thank you very much! (and also for your past answers and ideas)
Best regards,
Andreas
PS: Tried to replace the Resident with direct load... didn't help...