I am trying work out with MERGE statment to Insert / Update Dimension Table of Type SCD2 My source is a Table var to Merge with Dimension table. My MERGE statement is throwing an error as: The target table 'DM.DATA_ERROR.ERROR_DIMENSION' of the INSERT statement cannot be on either side of a (primary key, foreign key) relati...
Hello I am just in a process of starting a new task, wherein in i need to load Hybrid Dimension Table with SCD1 and SCD2. This need to be achieved as a SSIS Package. Can someone guide what would be the best way dealing this in SSIS, should i used SCD component or there is other way? What are the best practices for this. For SCD2 typ...
Hi all, hope i can get some help here. How can i make sure when joining data in ODS, it will only join data with the same batch of extraction? i.e. Products table has data row 1 - 10 from yesterday, row 11 - 20 from today. I would like to join yesterday sales record with data in Products table row 1 - 10 only, and today's sales record...