How many stages in Datawarehousing?

Data warehouse generally includes two stages

·         ETL

·         Report Generation

ETL (Extract- Transform-Load)

Short for extract, transform, load, three database functions that are combined into one tool

·         Extract -- the process of reading data from a source database.

·         Transform -- the process of converting the extracted data from its previous form into required form

·         Load -- the process of writing the data into the target database.

ETL is used to migrate data from one database to another, to form data marts and data warehouses and also to convert databases from one format to another format.

It is used to retrieve the data from various operational databases and is transformed into 

useful information and finally loaded into Data warehousing system.

1 INFORMATICA

2 ABINITO

3 DATASTAGE

4. BODI

5 ORACLE WAREHOUSE BUILDERS

Report generation

          In report generation, OLAP is used (i.e.) online analytical processing. It is a set of specification which allows the client applications in retrieving the data for analytical processing.

It is a specialized tool that sits between a database and user in order to provide various analyses of the data stored in the database.

OLAP Tool is a reporting tool which generates the reports that are useful for Decision support for top level management.

1. Business Objects
2. Cognos
3. Micro strategy
4. Hyperion
5. Oracle Express
6. Microsoft Analysis Services