Thursday, March 22, 2012

Clarifications on DW

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(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
--
"Imran" <anonymous@.discussions.microsoft.com> wrote in message
news:50d001c40001$bd78bbb0$a401280a@.phx.gbl...
> 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
>

No comments:

Post a Comment