views:

65

answers:

1

a bit confuse round here, does SSAS stored ETL result? or is it SSAS connect directly to the production databases?

+1  A: 

Best to have ETL move data from production databases into data warehouse database, then SSAS connects to data warehouse database.

There's far too much to explain here about the subject, some good reading is at http://www.ralphkimball.com/

Meff
Thanks for the link.
Irman
another question crossed on my mind, you said that ETL moves data from production into datawarehouse, well in "restructured" form or just copy whole the original then manipulate in SSAS?
Irman
@Irman, if you study the tutorials at the link I gave you, they explain the best way is to restructure the data. A production database will usually be normalised, but a data warehouse is usually denormalised. Good luck, and consider buying this book: http://www.amazon.co.uk/Microsoft-Data-Warehouse-Toolkit-Intelligence/dp/0471267155/ref=pd_sim_b_3/277-1431283-4145040
Meff
i was hoping a very simple short answer, well thats ok, thanks for the recommendation.
Irman