I knew that there are 4 ways to design data warehouse
which are enterprise data warehouse,dependent data mart,
independent data mart and federated warehouse but i want
to know that which job is suitable to each way?

In Access you can analyze tables and use the documenter to
write out all of the tables with their permissions, column
names, data types etc.  Is there a way to do this in SQL
Server?

I am trying to come to terms with some of the concepts of datawarehouse
architecture design. Utilising Microsoft tools, is it feasible that I build
cubes for each subject area and let users report off the cubes with Excel
and Reporting services, or should I also expose the data held ...

I installed anaylsis services 6 months after I installed
SQL 2000. Do I need to reinstall the SQL Service Packs?

   I hope someone can help me out with this matter.
I am trying to implement a DW Solution for an
Organization. I need to clarify the following points.
(1)what sort of indexes should i use on a DW Database to

I wish to know what is the solution from Microsoft to developing all stages of Data Warehouses on Microsoft platform
Is there a single book available for study/reference covering the above question
Thanks for the same

I have a problem in TempDB inflating rapidly up to 3 GB in
4-5 days, there is alot of stored procedures that use temp
tables and hash tables  the database is about 9 GB
Is there any tips that could help out in this

I'm designing data wareouse where I´m taking Data from an
operational Database, I´m creating dimension tables and
facta tables, my question is following.
When creating dimension tables I´m sometimes taking

I am using SQL Anywhere (database which comes with
powerbuilder) on Windows 2000 Server. I am migrating from
Sqlanywhere to sql server 2000. Will there be any problem
if I install MS SQl Server 2000 on Windwos 2000 server

    I'm somewhat new to data warehousing, and have some basic questions.
Let's say I have a fact table, named sales. The financial analyst
would like to be able to sort the sales information based on several
customer related attributes. Some of these attributes would include

I've a query to load my data warehouse, like this :
select C1, C2, C3....
from T1 inner join T2 ......
where not exists (Select * from FT1 where FT1.A = C1.A and FT1.B=C2.B...)

Is there a function I can put into my select clause that tell me what the
line number of the row is?
i.e. in Oracle you can do something like (Been a year since I've used
Oracle)

I would like to know what protocol / port Report Designer uses when performing the "Deploy " function from the IDE of Report Designer. For some reason it cannot connect with the report server.  I can browse the /rs/reportserver directory and can upload the RDL file through the IE ...

Is there an application out there that will allow us to cleanse/merge-purge
the name fields for a consumer as well as for a commercial data warehouse?
In other words, we want to take, for example, Walmart, Wal-Mart, Walmart
Corp, etc and boil it down to a single WalMart Corporation ...

I would like to incrementally update a cube but I am finding it some what
difficult. i would like to include the UID as a dimension and then be able
to "get the max(uid) from the cube" and then insert only rows from the fact
table that have a  greater UID. Can anyone recommend how ...