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
>

Choosing multiple DSV in the Cube Wizard

In the available data source views, I have 3 data source views. How do I choose more than one view from the available ones?I found a cludgy way to choose, by using the Back button and choosing tables from a different database, but, maybe there are better ways.|||

Hi Onamika,

You can not choose multiple DSVs in cube wizard. But when you have multiple DSs, you can add/remove more tables in DSV designer.

Yan

|||Precisely, I meant to say that. Using multiple sources with one DSV. also, create one cube based on one DSV.

check what table are lock by application

Dear All,

Sometimes the application cannot write record into SQL Server, but the source code of this application cannot be seen. Therefore, I wanna verify the MSSQL status. I have to check what table are locked by application. I wanna know the following information.

locked_table, locked_by_application, locked_status

Can I write some t-sql to get the information? I tried using Profiler, but it generates some useless information. Could you give me some suggestions?

Alex

Lock granularity is much wider than only a tables. That's for the first. Second is that SQL Server doesn't require any information about application and situation, when application doesn't provide it, is common. And, for the third, I would recommend you to solve your locking and blocking problems rather than prevent connections to get blocked.|||

In my opinion Profiler would be the best choice for You. The only thing what You have to do is to establish the appropriate configuration in outgoing parameters.

|||

Take a look at: How to monitor SQL Server 2000 blocking http://support.microsoft.com/default.aspx?scid=kb;en-us;q271509

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

thank SQL_Menace

I will try it

Alex

|||Hi Alex
here is a solution that microsoft does not recommend because it depends on the system objects
create table #Locks (SPID smallint , DBID smallint ,objID int ,indID smallint , Type nchar(4),resource nchar(16), mode nvarchar(8), status varchar(8))
insert into #locks execute sp_lock
select distinct object_name (objID) , Hostname , program_name,nt_userName , loginame , object_name (objID), mode
from master..sysprocesses s inner join #locks l on s.spid = l.spid
drop table #locks

find the values and the meanings of mode in the MSDN
HTH