Suppose we have a denormalized table with about 80 columns, and grows at the rate of ~10 million rows (about 5GB) per month.We currently have 3 1/2 years of data (~400M rows, ~200GB).
We\'re starting to load up a datawarehouse with data from event logs.We have a normal star schema where a row in the fact table represents one event.Our di开发者_JS百科mension tables are a typical com
I need to design a table for daily sales of pharmaceutical products. There are hundreds of types of products available {Name, code}.
I am building out some reporting stuff for our website (a decent sized site that gets several million pageviews a day), and am wondering if there are any good free/open source data warehousing systems
We\'re considering using SSIS to maintain a PostgreSql data warehouse. I\'ve used it before between SQL Servers with no problems, but am having a lot of difficulty getting it to play nicely with Postg