Tag Info

New answers tagged

1

If you have the Enterprise version of SQL Server, then I would recommend doing this using Change Data Capture (CDC). This is much easier and cleaner than setting up triggers to watch for changed data. Plus it reads the transaction log for changes and then logs those changes in system tables. You can use SSIS for your ETL. If you have 2012 installed, there ...


0

Here are my answers: Define relationships based on your surrogate keys and not your business keys. This is because this is what the SQL engine will use to optimize queries and this is the reason you have surrogate keys. Since surrogate keys are often integers, this simplifies the joins from using different data types such as strings which are less ...


1

Nothing should ever access the Staging Database, because that is where partially-cleansed data is stored and no systems should ever access partially cleansed data (except, of course, those processes that finish the cleansing and load the data into the Data Warehouse Database). Now, once the data has been fully cleansed then allowing Operational Source ...


1

There is a forum discussion which discusses this briefly, but quite well IMO: Tek Tips - Using a data warehouse as a source system Some points for consideration: Duplication of effort / Single source of the truth Will the operational system need to apply the same logic to the source data that the data warehouse is already performing? Read-only source ...



Top 50 recent answers are included