RTaylor2208 (9/30/2016)
How about combine all your data at the source and then replicate it to the subscriber using an indexed view as an alternative?When replicating an indexed view it will be created at the subscriber as a table.
http://www.informit.com/articles/article.aspx?p=607372&seqNum=3
The problem is to have the "Combined data" updated close to real time from production, regardless of where the combined data resides.