Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    4

    Data warehouse architecture

    hi ,

    if company with heterogeneous databases and branches all over the world want to build data warehouse , what will be the best architecture ?

    From what I read until now I think it is federated data ware house. But I am not sure if I understand it ,they always talk about data marts when talking about federation, but my idea is to build data warehouse for all the branches in each country to meet their requirement.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Read Inmon's books if you want to build a true data warehouse. Read Kimball if you just want to build datamarts.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •