• You can go with the one data warehouse approach. I would employ the use of schemas to denote where the information comes from. Example, china.orders will be the same as usa.orders architectually, just the source of the data is the difference. With these different schemas you could build them on different database files on your server.

    ----------------------------------------------------