DTS - validation
I require a easy and best solution for the following situation
Actually i have identical 6 operational databases running at 6 different locations. All database structures remain same. I have designed a DataWarehouse database and created a OLAP cube. Periodically i wanted to pupm data from all 6 operational databases to my datawarehouse database using DTS.
Before pumping i need to verify that the data to be copied does not exist already in the DataWarehouse table.
Please suggest me a good idea to proceed.
Thanks in advance
Are these databases only connectable to the central warehouse only periodically? If not, and they can access all the time, I would suggest a replication technique, as opposed to a data pump.
What database is this with?