• I think I'd be inclined to start with one DW for all countries, build views to pull out data country-by-country or for all countries, then split up tables if/when growth starts impacting performance. At that time, you only have to change the views. Your application layer will continue to work.

    Also, if you're in a rapid growth situation, remember to partition your tables by some scheme that makes the most business sense.