When setting up the DWH or reporting database, I would like to separate the staging data (data dump from ADAM) from the dimensional data.
The current implementation for exporting the data, creates the output tables in the dbo schema. I would like to have that configurable, so a schema like "staging" could be used. Doing so, will make it more easy to secure the staging data to end users.
Another way of shielding the staging data is to use a different database: ADAMStaging and ADAMReporting. However, the queries are more complicated to transform the staging data to the reporting format if two databases are used, where using one database with different schemas is better.
Customer support service by UserEcho