DTS - validation
ramkanna last edited by
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
rewind last edited by
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?