quote:

---

Our warehouse is currently 26+ Gigs and we load it with delta's daily in under 2 hours (along with the recon reports...

DavidBurrows, I've just "googled" the web on this matter and it seems that a datamart is designed for 1 purpose where a datawarehouse has a larger (probably company-wide) scope....

@davidburrows thanks for sharing. What in fact is a datamart ?

@dm thanks, can you give an idea what the quirks are ?

Currently we have a...

@jeremy-2 Kemp, @Antares686 thanks for the info. I can't post code/DDL because this is problem that will be most likely in a further state of...

in risc of getting flamed:

Are any of those tools available on other platforms as Windows ? (Linux, Mac OS X)

Thanks

thanks, nyulg, do you have any experience with this on OLAP databases ?

Edited by - hbkdba on 08/01/2003 05:10:25 AM

Is the following statement a valid example of the checksum-statement ? I've read about the * on msdn (-which does not mention the abality to use the table-qualifications as...

@jpipes: Thanks a lot ! This is exactly what we are looking for. A first test:

two tables containing 1.2 million rows (temp and ods). After...

can't you migrate into 1 of the 2 databases ? Oracle or SQL server, so only one database engine is needed ?

Putting them together might at least giving you troubles...

be aware of the fact that unicodes doubles your space needs and therefore also slows down full-table scans

ub2b,

I've written such a script (a while ago) but it's not yet done, it still has several errors, but it is a startingpoint.

If you feel like debugging it and returning...

acudlip,

some extra questions:

1) which reporting tool

2) expected growth of the OLAP DB

3) load method

4) source of the data

5) is hardware / O.S. choosen already ?

acudlip,

Please tell something more about your needs:

number of users

types of transactions (many small, many large, reporting, ...)

OLTP/OLAP

number of concurrent users

...

Both databases have a reason of existence, neither of them renders the other obsolete ...

There are points where MS Sql server rules:

1) ease of installation

2) user-friendlyness of enterprise manager

3) abilities...