One of my colleague here gave me this information : The foll. are the top products in the market used for Datawarehousing : In Datawarehousing : 1.Data stores can be:Informix,DB2,Oracle,Nucleus,Teradata, SQL Server
2. Popular ETL Tools(For populating Data warehouse): Ascential , Informatica and Abinitio , Sagent and Data stage
3. Datamodelling tools : Erwin,Oracle Designer,ER Studio
4. Reporting/Analysis tools: Business Objects, hyperion , cogsos, brio, spss , crystal reports I do not know what kind of support they have for J2EE. For example, his company uses the following for their Datawarehousing project involving, almost 2 million customer's data : DB Source : Oracle 9i DB Data warehouse : Nucleus ETL : Ab initio Reporting (ODS) : Brio
I don't like that guy. The tiny ad agrees with me.
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop