gbritton1 (4/21/2014)
Kinda hard to answer without knowing lots more.e.g.
1. will most BI reporting be country-specific? (argues for separation)
2. what are the expected table sizes? (if small-ish, no value in separating by country)
3. would your proposed DWs be housed in the same physical server farm or locally in the countries they represent? (argues for separation)
4. How costly will the ETL to the "master" DW be?
1. Mostly Yes, but Head office BI will look at entire operations
2. Table size is small in UK <2GB but expected US to be 10 fold in data, and china even more so assume that would grow very quickly if successful.
3. We are looking into Azure just now for our websites but we will most defiantly have a onsite data center hosting our warehouse applications etc
4. No idea just now, the UK DW hasten even been built, but looking to utilize SQL 2014 performance improvements as much as possible.
thanks for the reply.