Hi Vincent,
Thanks a lot for this article (and its companions "Data Warehouse Loading" and "Upsert Dimension Tables") : a real gold mine 🙂 completing on the practical side some points developed by Ralph Kimball in his excellent book "The Microsoft Data Warehouse Toolkit".
I haven't covered audit, control, restore, MDB and EAI (topic number 7, 8, 9, 10, 11 - see planned content on the DW Loading article) as I've been busy writing a book and another article on using DW for CRM but if a lot of people want it please tell me and I'll write it for you guys.
Please do ! I'm looking forward to read it !
Also an other request: some tips or best practices concerning the use of indexes for both dimension and fact tables. I have read lots of articles about the subject just to get lots of contradictory information. I would really appreciate the advise of a long time practioner ;).
Luc
MCTS SQL Server 2005 BI
Luc Magnée
MCTS BI
Antwerp - Belgium