• Thanks for the replays

    and the one DW with schema separated tables seems to be coming up lots.

    If this is employed the DW will reside in one location say datacenter UK. would my ETL workload have a large impack in gettign the date from US, China etc.