Re: Creating a data warehouse.

This response is very 'on-point' - most of the important work in creating a DW takes place before installing/using a single piece of software -it is in understanding the needs/desires of the clients and learning from them how the data is used now and how they would like to use it....
Moreover, there is a long 'data cleansing' process to make sure you are 'warehousing' valid data..This involves extensive consultation with the data producers as well as the data 'consumers' and involves an intimate knowledge of the organization's business rules...( As you have probably now figured out, Data Warehouse design is not a trivial undertaking...)

We use Ascential's Quality Manager for Data Cleansing tasks,  in conjunction with DataStage( it is the Extended Edition, it's actual product code is DSXE so I called it DataStage XE )  and Metabroker plug-ins for Oracle's repository metadata ( we are a mostly Oracle shop) - we also have the Merant ODBC drivers for other data sources..

hth,
John Greco
ETL Tool Consultant
MnDOT

pagesflames_at_usa.net (Dusan Bolek) wrote:

>"LVF" <lisalou1_at_mediaone.net> wrote in message news:<fUDc7.31645$bm5.12480205_at_typhoon.ne.mediaone.net>...
>> Hey Thanks for the input. So what you are saying is that if I have an
>> Oracle database configured for a data warehouse, Oracle data warehouse
>> builder and an OLTP database full of transactional data I have all that is
>> needed to build a warehouse?
>
>I don't think so. My opinion is that technical solutions are not very
>important compared to business solutions in datawarehousing. There is
>a big job to do in analytical field, but that's for long debate.
>You didn't gave us any information about your DW, so is hard to
>determine the complexity of you DW. Hovewer, only design of DW
>prototype in banking sector was for me and my team work for ten months
>and it was mainly about business and design issues not about technical
>ones.
>
>P.S. I was really suprised when you mentioned Standard Edition. SE is
>not suitable for even smaller DW, typical DW needs not only EE, but
>also several extra options.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Aug 10 2001 - 09:10:10 CDT