Informatica BI Tool

I want to build my career in the field of Information Technology and for this I have decided to do Informatica Business intelligence tools course. Will you please provide me some details about this and also tell me types of transformations available for this tool?

[Shaleen]

Business intelligence tools are a type of application software designed to retrieve, analyze, transform and report data for business intelligence.

The key general categories of business intelligence tools are:

Spreadsheets
Reporting and querying software: tools that extract, sort, summarize, and present selected data
OLAP: Online analytical processing
Digital dashboards
Data mining
Process Visualization
Data warehousing
Local information systems

Informatica BI Tool details:

In 2006, Informatica launched its Informatica Cloud business

Types of transformations:

Active : One that can change the number of rows being output.
Passive : One that cannot change the number of rows being output.
Connected : One that has at least one link with other transformations or objects in a mapping
Unconnected : One that does not have any link with any transformations or objects in a mapping

Also, Active transformation are recognized by any of the following three factors:

the transformation changes the row type
the transformation changes the row order
transaction control happens in the transformation

List of the most popular ETL tools:

Informatica - Power Center
IBM - Websphere DataStage(Formerly known as Ascential DataStage)
SAP - BusinessObjects Data Integrator
IBM - Cognos Data Manager (Formerly known as Cognos DecisionStream)
Microsoft - SQL Server Integration Services
Oracle - Data Integrator (Formerly known as Sunopsis Data Conductor)
SAS - Data Integration Studio
Oracle - Warehouse Builder
AB Initio
Information Builders - Data Migrator
Pentaho - Pentaho Data Integration
Embarcadero Technologies - DT/Studio
IKAN - ETL4ALL
IBM - DB2 Warehouse Edition
Pervasive - Data Integrator
ETL Solutions Ltd. - Transformation Manager
Group 1 Software (Sagent) - DataFlow
Sybase - Data Integrated Suite ETL
Talend - Talend Open Studio
Expressor Software - Expressor Semantic Data Integration System
Elixir - Elixir Repertoire
OpenSys - CloverETL