Tag Info

New answers tagged


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 ...


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