Post reply

Load Data Mart without reduce Read-Performance

  • September 3, 2018 at 8:24 am

    #408329

    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

    #2004267

    info 58414 - Monday, September 3, 2018 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

    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