DTS - Transform data from OLTP to OLAP

[sarithmann]

Hi
I want to transform data from one OLTP database to another OLAP database(Actualy to a fact table).

I need to know how to do it in DTS, using queries.
(More: using Data driven query properties)

Thanx.
Sarith.

 

[DLSQL]

Sarith,

The specific answer you are looking for depends on your needs and is very complex. I would need to understand your OLTP schema and your OLAP schema (Star vs snowflake and what your dimension tables look like).

The best I can do for you is point you at some good resources, like Professional SQL Server 2000 DTS, which includes several chapters on doing DTS for loading into a DataWarehouse.

http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=15KDULK8M9&isbn=0764543687&itm=1

(url may wrap)

Additionally, the are several Microsoft Official Curriculum courses on DataWarehousing. One on DW Design (2074), one on writing MDX queries (2093), and the one you probably want, on ETL with DTS (2092).

DL
MCDBA, MCSD, MCT, etc.