Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  question to hub-and-spoke data warehouse architekt

Author  Topic  no idea Starting Member 1 Post Posted - 2009-05-11 : 06:16:04 hello, i hope someone can help me out. in addition to the core dwh i have an so called operational data store (ods). from what i understand i built data marts from the dwh but how is it with the ods? do i built data marts from data in the ods too or get the business intelligence tools direct access to the ods? unfortunately i cannot found anything about that in the literature. my guess would be direct access but i have to verify that before i write that in my thesis. kind regards patrick