March 1, 2005 at 2:21 am
I am just starting on Data Warehousing and do not understand what the best practice is to get the data warehouse refreshed.
As I understand it, the (best practice) sequence is this
1. Create new DW database on a new server from the OLTP server
2. Populate a Fact table and star tables from possibly complex queries to put the data into DW best format.
3. Create cubes off the Data Warehouse database
4. Refresh the cubes daily, which will pick up the data from the Data Warehouse.
My question is this:
What is the best practice to refresh the data warehouse database itself from the OLTP database. I know I should use DTS, but it doesn't seem right to make a complete refersh of the DW, especially if the OLTP is many GB in size, so how are only new records and changes identified and uploaded, other than by using transaction logs which DTS cannot see.
Any help/guidance on this greatly appreciated.
thanks
Neil.
March 1, 2005 at 5:03 pm
One of cases needs full refresh is the data changes. Some applications do change historical records.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply