sql server data warehouse: A few links for you:

http://www.intelligententerprise.com/030630/611warehouse1_1.shtml

http://www.intelligententerprise.com/030531/609warehouse1_1.shtml

http://www.intelligententerprise.com/030101/602warehouse1_1.shtml

You also might consider buying Wrox's "Professional DTS programming for SQL
2000"

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]

Hi,
What information do you have for populating the data warehouse ( With ETL
tools ) ?
Where can I find books/e-books or any web site about the Subject?

Thanks.

[quoted text, click to view]

If you want to just populate the data warehouse with _some_ data, there is a
great test data generation tool available. Read the release below:

---Announcing the official release of GS DataGenerator ver 1.5.0. Download a
free 30-day functional trial at
http://www.gsapps.com/products/datagenerator.

GS DataGenerator is a powerful test data generator application designed to
populate a selected database with simulated, but "intelligent" and realistic
records.

GS DataGenerator enables users to:
o Complete functional application testing - inflate databases with
meaningful data, rather than just random data
o Create industry-specific data that can be used for a customized client
demonstration - applicable for sales teams to make demos more meaningful to
the clients
o Protect data privacy by creating a clone of the existing data and masking
confidential values - scramble the data, or simply hide the original data
o Accelerate the development cycle by simplifying testing and prototyping -
reusable objects and metadata-based application allow for quicker
application testing

Although the records are artificial, a user can mimic business trends, data
patterns and complex business logic, including potential error-generation
for testing complex error handling.

By combining numerous pre-defined functions, custom lists, JScript and SQL
programming support, and an intuitive GUI, GS DataGenerator is the most
advanced intelligent test data generator tool available.

GS DataGenerator also includes the following unique features:
o Creates business trends and patterns
o Simulates business workflows
o Mimics potential data errors
o Automatically detects changes in the underlying data model

--

Romit Mehta.
Global Software Applications
Efficiency through innovation
http://www.gsapps.com
GS DataGenerator is at http://www.gsapps.com/products/datagenerator