Advice needed: DW and ETL tools

Hi!
I'm involved in building a medium sized ware house with MS SQLServer 2000=20
as the backend. I've been searching for some good tools for SQLServer to=20
help me with the demanding tasks of planning and building the database and =
(preferrably the same tool) making the mappings and data transformations=20
when populating the database, but still I've not come across any that has=20
satisfied my needs. Oracle has a great tool for this called Oracle=20
Warehouse Builder, but haven't seen anything like it for MS databases.=20
Therefore I'm asking: Does anyone know about a tool that can be used in=20
planning, deploying and maintaining a data warehouse built on a MS=20
SQLServer 2000? Doesn't matter if it has a price tag on it or not
S=F6ren Hakola
FinlandI think that anyone that uses SQL Server to deploy a Data Warehouse... uses
SQL Server 2000 capabilities only. And it's cheeper )
- Diagram: create logic models with direct link to the tables
- Tables: Info repository
- Data Transformation Services (DTS): ETL, data transformation (populate the
tables)
- Jobs: schedule DTS for automatic ETL
- Analysis Services: If you desire to work with a MOLAP tool
Other tools:
Data Stage (Unix and Windows, all databases) - Top tool, expensive
Informatica (Unix and Windows, all databases) - Top tool, expensive|||Thanks for the response. I'll check those out!
Greetings
S.sql

AdventureWorksDW

Hi everybody,

I'm searching for a full description of AdventureWorksDW and also its relationship with AdventureWorks database.

Tanx

Hello. I have not found a full documentation but perhaps Books On Line can tell you something.

A short description is that AdventureWorks is the OLTP-version(read transaction system version) of a fictive company that sells bicycles and related equipment on the internet.

AdventureWorksDW is the data warehouse structure of this company's business that include several starschemas /data marts. This structure is for analysis, not for entering transactions. After installing tools and samples, that is part of the SQL Server 2005 installation, you will also find an Aventure Works cube project built on top of the AdventureWorksDW database.

HTH

Thomas Ivarsson