Data warehouse

[TurkBear]

Daniel Morgan <damorgan@exxesolutions.com> wrote:
Daniela Giovenzana wrote: We need to install a data warehouse on a windows server. The packages we have to buy are: Database: Oracle 9.0.1.2 or next Enterprise Edition. Application Server: Oracle9iAS 1.0.2.2 or next. Oracle Enterprise Manager: OEM 9.0.1. Oracle Workflow: Oracle Workflow server: 2.6.1/2.6.2 (2.6.2 is better) and Workflow client: 2.6.1 Warehouse Builder: Release 9.03 Is it correct?No.The minimum Oracle version you should be using is 9.2.0.1, preferably 9.2.0.39iAS and the others may be useful for building a front-end or as tools for theback-end butserve no purpose specifically related to the creation of a data warehouse.
Just my 2c:
Of course, all you really Need from Oracle for a data warehouse is the RDBMS ( and Client for SqlNet, maybe)
All the other things you mentioned ( AS excluded, since it is not related to a warehouse) may be good from Oracle but there
may be better tools to do those tasks from the many 3rd party suppliers out there..
( I have found that, while much better than they used to be, Oracle is a great company for its RDBMS and not so great for
its tools....)






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

[Daniela Giovenzana]

"TurkBear" <john.greco@dot.state.mn.us> ha scritto nel messaggio
news:acbmfvcli8tql8n9crg9njd8vj2j69a3h0@4ax.com... Daniel Morgan <damorgan@exxesolutions.com> wrote:Daniela Giovenzana wrote: We need to install a data warehouse on a windows server. The packages we have to buy are: Database: Oracle 9.0.1.2 or next Enterprise Edition. Application Server: Oracle9iAS 1.0.2.2 or next. Oracle Enterprise Manager: OEM 9.0.1. Oracle Workflow: Oracle Workflow server: 2.6.1/2.6.2 (2.6.2 is better)
and Workflow client: 2.6.1 Warehouse Builder: Release 9.03 Is it correct?No.The minimum Oracle version you should be using is 9.2.0.1, preferably
9.2.0.39iAS and the others may be useful for building a front-end or as tools
for theback-end butserve no purpose specifically related to the creation of a data
warehouse. Just my 2c: Of course, all you really Need from Oracle for a data warehouse is the
RDBMS ( and Client for SqlNet, maybe) All the other things you mentioned ( AS excluded, since it is not related
to a warehouse) may be good from Oracle but there may be better tools to do those tasks from the many 3rd party suppliers
out there.. ( I have found that, while much better than they used to be, Oracle is a
great company for its RDBMS and not so great for its tools....) ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---

Can you give me some ideas about these tools.
Thanks