sql server data warehouse: Clarifications on DW -- sql server data warehouse

Clarifications on DW

Imran
3/1/2004 6:54:54 PM

sql server data warehouse:

Hi,
hope someone could help me out with these issues I
have.

(1)when u do an extraction from the source database table
to the destination database table using DTS, does dts copy
only the data that is not available in the destination
table or does it Reload the entire sets of rows in the
source table irrespective of whether its there are not? is
it possible to do incremental loads?

(2)how can changes be managed in DW Database? example:
take a situation where I extract inventory data from my
OLTP and put it on to a DW Database on day 1. suppose i go
an change the Quantity on Hand column for a particlur
record in the OLTP, how can i reflect this change on my DW
wihout doing a load. is it possbile to monitor for changes
in the OLTP and update same in the DW?

(3)where can i get some tutorials n writing front end
applications to query a Cube created in Analysis Server?

Thanks in Advance for your help

Regards
Imran

Re: Clarifications on DW

Ray Higdon
3/1/2004 10:40:09 PM

(1) Yes it is possible to do incremental loads. See this page for details -
http://www.sqldts.com/?277,1

(2) This is the beauty of SCD's - slowly changing dimensions - above link
will help along with this page - http://www.dbmsmag.com/9604d05.html

(3) Before writing your own, you might want to look at reporting services -
http://www.microsoft.com/sql/reporting/default.asp

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]