I have to do a host of roll ups on sales fact data.
In SSIS which have you found to faster/better: the
Aggregate Transformation or a SQL stored procedure?
There are also a lot of Sales Ranks we need to calculate.
So far it seems SQL might be the only way [SELECT ROW_NUMBER() OVER (PARTITION BY Date_ID ORDER BY Sales_Qty desc) AS Rank ...]
If there's better way with a SSIS transformation, that would be
a great help too.
[sorry if this is a repeat, did search forum but didn't find.]
Skål - jh