How do I prevent an ETL, that populates cubes by deleting all data in a Star Schema database from scratch each and every time, and instead update just changes?
We have an ETL process that populates a star schema database and then proceeds to create cubes. Problem being its blowing out the star schema ad re doing everything for scratch every single time. Which is incredibly time consuming. We are using SQL Server SSAS 2014 Standard. Is there a way not to do this anymore and just update the information that has changed?