How do I consolidate multiple publications into 1 consolidated table on the subscriber? For example. Consider a very simple sales model where we replicate sales data from the stores to the central office.
Store 1 Sales Table
=====================
Item Qty Amt
=====================
111 2 10.00
222 1 7.00
333 1 12.00
Store 2 Sales Table
=====================
Item Qty Amt
=====================
111 2 18.00
222 1 13.00
333 1 4.00
How do I replicate these two sales publications from the publisher to ONE consolidated sales table at the subscriber:
Central Office
==============================
Store Item Qty Amt
==============================
1 111 2 10.00
1 222 1 7.00
1 333 1 12.00
2 111 2 18.00
2 222 1 13.00
2 333 1 4.00