Hi, i Studied Both Relational and Multidimentional model for Data Warehousing,
but i don't know which is the best to do? can u Please Guide me?
Thx

Do you know any tool ou method to help the migration of an entire DW
repository in SQL Server 2000 to Oracle? And I mean the Dtata Transformation
Services too... I think it is veru difficult to migrate DTS to DML in
Oracle, but who knows there is some tool that transforms DTSs ...

I need to improve the sql setup at my current location (long term contract)
Currently there are
100+ msde installations  (1 gb average running a retail back end processes)
Backup to disk and tape locally only.

I am building a fact table containing 6 measures.  For about 90% of the
rows, 3-4 measures will be zero.  What is the best data type to use for
the measures?

A requirement of our DW project is that we store Dimensional changes,
and it appears the SCD Type 2 method sounds best for that.... But say
you have 30+ Dimension tables, all SCD T2.  Another requirement is the
users can do Ad-Hoc reporting, where they could potentially join many

I have tens of thosands of records needed to be insert to SQLserver on each
query.
My experience is that each 10 thansands records needs 7 sec.
Is there any method to increase the speed?

i need to do create reports that perform queries where the results are
percentages of total count divided by counts based on different
subquery where values.
a la ...

Heres my scenario:
I have a dimension which has levels. For example, I have this:
7ZZZZ
  70ZZZ

Hi, which DMBS Do u Prefer For  a DW?

I am currently deduping a data warehouse containing around 3 million
records. Most of my dedupe scripts run in 3 or 4 minutes but the
scripts which compare datetime fields take up to 3 hours. I have a
non-clustered index on the date column. Can anybody offer any advice on

Hope anyone can give me ideas on how to solve this problem.
I have a cube with some calculated measures. The application that access
this cube uses query-scope calculated member, for example to get the the
cancer incidence rate per 100,000 in 3 counties, the query would be:

Is there anyway to find how many users connected to cube
thanks
Kalyan

ANy body can Introduce me a White Paper about Granularity Manager, or A tool
for this Purpose?

Hi All
We are having problem on indexed views when we try to join to more than one
table that is not part of the original indexed view in a query.  Has anybody
seen a similar problem?

I am planning to do datawarehousing and develop some cubes but i am not too
sure of how to use MDX queries .
 Where can i get help on MDX queries ?
 appreciate ur advise