September 3, 2018 at 8:24 am
Hi,
what is the best practice for decoupling a DataMart (SQL 2014) which is filled several times a day by the DWH via ETL load. The goal is that the end user is not impaired in terms of performance during a load.
One option would be Scalable Shared Database. Or are there even more elegant solutions for this? Replicate, Cloud, Stretch DB ? More than 20 Fact-Tables; all Layer on one Server;
Regards
Nicole
September 3, 2018 at 8:33 am
info 58414 - Monday, September 3, 2018 8:24 AMHi,
what is the best practice for decoupling a DataMart (SQL 2014) which is filled several times a day by the DWH via ETL load. The goal is that the end user is not impaired in terms of performance during a load.
One option would be Scalable Shared Database. Or are there even more elegant solutions for this? Replicate, Cloud, Stretch DB ? More than 20 Fact-Tables; all Layer on one Server;
Regards
Nicole
With >2500 points, you should know better than to cross-post. Responses here please.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply