Data warehouse staging design 1

[jtamma]

Are there any good books/sites/tips/discussion forums on data warehouse staging area design. I googled it but didnt get much help.

Thanks.

 

[RiverGuy]

The book Data Warehouse ETL Toolkit might be worth a look. I can't remember right off hand how much information it has on staging areas, but I believe there is some information in it. My advice would be to check out the local bookstore and see what books they have in the Toolkit series. I'm sure you'd get lots of advice in this forum as well.

 

[dmcmunn]

The ETL Toolkit is in fact has a great overview on architecture with some suggestions on metadata that should be kept as data moves from the market (sources) through the kitchen (ETL processing) to the table (reporting). I will be publishing my perspective on these data structures over my Christmas 2007 vacation here:

http://www.ipcdesigns.com/etl_metadata/

Feel free to see my other *freeware* for the DIY practitioner of data profiling and time dimensions at:

http://www.ipcdesigns.com/data_profiling/

http://www.ipcdesigns.com/dim_date/

 

[chamilz]

This might help you.

http://www.msftdwtoolkit.com/ToolsandUtilities/ToolandUtilities.htm

These tools have to use with the book, "Microsoft Data Warehouse Toolkit"