Yes I tested it on sql server 2005 with sucess. Indeed as said above the best performance is often obtained by exporting to a text file from SQL SERVER and...

You can use the default behavior for your measure on Organization and add a measure 'Estimated Order Count' which is a count on your fact table and a calculation for...

You can use the Microsoft Connectors for Oracle by Attunity which is free and offers better performances than the standard SSIS component.

You could have a look to the Ralph Kimball books or articles if you need a more conceptual approch of dimensions or multidimensionnal modelisation. It's not perhaps the perfect theory...

You can use the Kimball Method SSIS Slowly Changing Dimension Component[/url]. This component supplies six outputs: Unchanged, New, Expired SCD2, Updated SCD1, Auditing, and Invalid Input and is much faster...