What is the best way to replicate data from a view containing a LEFT OUTER JOIN (so cannot be indexed) to a physical fact table on the subscriber in as real time a fashion as possible?
I have heard of the use of custom sync objects etc.. can anyone suggest the best way forward and any references?
Is CDC a candidate for this type of task?
Thanks in advance
View Complete Post