Hi Allan
1)Is there any site which would explain the Process of
Extract Transform Load in a detailed manner?
2)Is ETL A part of datawarehousing ?if so how?
3)How well does DTS Support the concept of ETL is there
any documentation on DTS Support for ETL

Thanks in advance
Sunny

Wow.

1. Sites:

http://www.datawarehouse.com/iknowle...ContentID=4072
http://www.evaltech.com/wpapers/dwandetlprocessing.htm


2. My answer to this is no. ETL is about Extracting information from a
place, Transforming/cleansing it or not and finally loading it to a place,
maybe the same place maybe a different one. A Data Warehouse doesn't need
to be involved although very very frequently is.

3. DTS is a good ETL tool. It does not, in this release, support
everything that other vendors support. I am not sure there are tenets to
ETL like Codds NFs unless you take the ETL to be the tenets..

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sunny" <anonymous (AT) discussions (DOT) microsoft.com> wrote