There are 5 Key areas to understand in Data Warehousing-Informtica

There are 5 Key areas to understand in Data  Warehousing:(To understand this concept,  knowledge on Relational  databases and SQL is necessary)

1.DATABASE
2.ETL [Extraction, Transformation & Loading]
3.OLAP
4.REPORTING
5.METADATA
- - - - - - - - - - - -
1.DATABASE –
To understand the storage of data with RDBMS Process

Popular Relational Databases are:

*ORACLE
* MICROSOFT SQL SERVER
*IBM DB2
*TERADATA
*SYBASE
*MYSQL

2.ETL [Extraction; Transformation & Loading] – To understand cleansing of Data from DB’s.

Popular ETL Tools are:

*INFORMATICA
*DATA INTEGRATION STUDIO [SAS]
*ODI
*SQL Server Integration Services [Microsoft]
*DATA STAGE
*AB INITIO
*TALEND and many more..

3.OLAP : – To understand Slicing & Dicing of the Data.

Popular OLAP Tools are:

*OBIEE [Oracle Business Intelligence]
*BUSINESS OBJECTS [SAP]
*OLAP CUBE STUDIO [SAS]
*COGNOS [IBM]
*SQL Server Analysis Services [Microsoft]
*MICROSTRATEGY
* PALO OLAP SERVER
*HYPERION [Oracle] and many more...

4.REPORTING – To understand the Reporting requirement on Regular Automations & Adhoc’s

Popular Reporting Tools are:

*CRYSTAL REPORTS [SAP]
*MICROSTRATEGY
*OBIEE [Oracle Business Intelligence]
*WEB REPORT STUDIO [SAS]
*COGNOS [IBM]
*SQL Server Reporting Services [Microsoft]
*HYPERION [Oracle]
*Actuate
*Jaspersoft
*Pentaho and many more...

5. METADATA – To build data repositories from the scratch and it is a rare phenomenon