I need some help in my load script. I am loading invoice headers and then joining the lines where my amount field gets read from. However, I want to exclude all invoices where the Sum(Amount) = 0.
What is the best way to approach this?
I have tried loading all into a temp table, then loading the fact as a resident from temp table where sum(Amount) > 0 and grouping by DocNumber. But it doesnt seem to work...
