Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Data Transformation Services (DTS)

Interview Question :: SQL Server 2000 updating and inserting from one table to another

Hello,

I have a datawarehouse where I pull in data from Progress database to SQL Server 2000. I use DTS to copy the new data from a table from progress to SQL server but the problem is that some of the data are not new but updated data. So my question is how do I use the DTS to update if the data is already in there and insert if it is new data?

Another one of my plan was to insert all the previous days transaction into a temp table and use a store procedure to insert and update the datawarehouse table. which solution is better?

Answers to "SQL Server 2000 updating and inserting from one table to another"

RE: SQL Server 2000 updating and inserting from one table to another?
I think that you can do this using DTS but I don’t use it often enough to be sure. Importing to a temporary table will use more space but should be faster.
Vote for this answer ::

RE: SQL Server 2000 updating and inserting from one table to another?
adopt the approach first extract the data from the source system... then load it into a temporary or staging table then validate the data... then assign surrogate keys to the data... then add the data into your warehouse... how you add the data depends on how you've categorised your requirement.... is your data static slowly changing or volatile... what is the meaning / purpose of the updated data.... is it corrections or a true data/attribute change that will govern how you store it..
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Data Transformation Services (DTS)

Interview Question :: SQL Server 2000 updating and inserting from one table to another

Top Tags