Browse by Tags

  • Problem: Initial parameters for a data warehouse staging server

    We'd like to start using partitioning and noticed the parallel parameters were wrong. Can someone please recommend better initial parameters for an Oracle 9i Enterprise server running on Linux with one hyperthreaded Xeon, 2GB ram, 14x10K SCSI disks RAID5 (one big volume) used as a data warehouse...
    Posted to 9.x (Forum) by software on 06-11-2009
  • Problem: Data mart vs Data warehouse

    Dear Expert, I am just learning about Data marts and Data warehouse and I can't seem to get my hands around this concept. It seems like Data marts are dependent of a Data warehouse and it seems like a Data warehouse is more efficient in getting results for end-users. My questions would be why would...
    Posted to Miscellaneous (Forum) by software on 06-11-2009
  • Problem: Data Warehouse Design, Fact table with 40 attributes

    I am designing a data warehouse for a telecoms company. I have read several books and articles on data warehousing including Kimballs book on Dimensional Modelling and come up with a draft design for one of the core processes. My design has 13 Dimensions which according to kimball is perfectly legal...
    Posted to OLAP (Forum) by software on 06-09-2009
  • Problem: Data warehouse design, fact to dimention row count ratio

    We are working on a data warehouse project for one of our customers. We are now towards the end of the project and have real data going into the warehouse. The database has 13 dimensions and a fact table with 62 attributes. Currently the fact table has 7 million records in it and most of the dimensions...
    Posted to OLAP (Forum) by software on 06-09-2009
Page 1 of 1 (4 items)