OraFAQ Forum: Data Integration

Home » Developer & Programmer » Data Integration » Datwarehouse

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datwarehouse [message #93065]

Wed, 04 December 2002 19:02

murli
Messages: 25
Registered: November 2002

Junior Member

Hi Gurus
I am new to datawarehouse.Can you please let me know what is ETL in Datawarehouse means.I have worked on discover.What actually Datawatehouse means.what type of a tool it is.I have downloaded 9i warehouse builder from net.Does it consists of ETL.Please let me know.
Regards

Report message to a moderator

Re: Datwarehouse [message #93068 is a reply to message #93065]

Tue, 10 December 2002 07:26

mikeZ
Messages: 2
Registered: September 2002

Junior Member

ETL means Extracting, Transforming the raw data from sources and Loading it into the Data warehouse

Report message to a moderator

Re: Datwarehouse [message #93078 is a reply to message #93065]

Fri, 20 December 2002 00:23

vishwakumar
Messages: 2
Registered: December 2002

Junior Member

Hi
Let me highlight you the basics of ETL.

DATAWAREHOUSE IS NOT A TOOL IT IS A CONCEPT !!!!!.

E -Extraction - This process is involved in the extraction of source data to your destination from any source system(legacy, text files or csv files....).

T - Transformation - Though the data is just extracted into your destination the data has to be transformed and cleansed so that meaningful and validated reaches
the end user.

L - The transformed into the final warehouse or database(in technical terms) ansd the reports are created from this final destination

A simple process flow would be as follows:

SOurce -----> STaging Area -----> Final DWH

DWH -DataWareHouse

Let me know if you would need any other information.

Report message to a moderator

Re: Datwarehouse [message #93157 is a reply to message #93068]

Thu, 24 April 2003 06:52

Lars Olof Sjöström
Messages: 1
Registered: April 2003

Junior Member

And transforming can be of several flavors. Cleaning the data from errors and make them the same format are two flavors.

Report message to a moderator

Previous Topic:	Error ORA-00600 in OWB
Next Topic:	Multiple data files in 1 external table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 15 08:35:54 CST 2025