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 

    Ram

     

     



  • 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?

    -REW
     


Log in to reply