We've recently moved from a type 1 only DW design to a type 2 SCD DW and are struggling with our process to migrate data from one environment to another.
New application development often integrates data already in production requiring us to refresh our TEST or QA dbs with this data.
Because of the use of surrogate keys, in order to migrate fact data from one environment to another, we first have to re-synchronize all the master data.
We are now considering setting up a series of MVs or export/imports to refresh fact and master data across environments on a regular schedule.
I was wondering if others have faced this issue and if they have taken a similar or different approach?
New application development often integrates data already in production requiring us to refresh our TEST or QA dbs with this data.
Because of the use of surrogate keys, in order to migrate fact data from one environment to another, we first have to re-synchronize all the master data.
We are now considering setting up a series of MVs or export/imports to refresh fact and master data across environments on a regular schedule.
I was wondering if others have faced this issue and if they have taken a similar or different approach?