Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Insert & Update

Author  Topic 

tams115
Starting Member

7 Posts

Posted - 2006-03-09 : 03:36:52
Hi Every one.
i am a student n doing my final year project on data warehousing.
so plz help coz i dont hv much knowldge abt it.

I loaded data from flat file to oracle using DTS then i made DTS shedule and set the time for updation. i want to insert new rather than previous one n if there is any change in previous data that updata it n new data insert in it.plz some one guide me how i can do it. thanx

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2006-03-09 : 03:40:56
Google is your freind.

http://www.google.com/search?hl=en&q=%22Surrogate+Keys%22%3B+%22Data+Warehousing%22&btnG=Google+Search


Duane.
Go to Top of Page
   

- Advertisement -