#1
3rd December 2015, 05:31 PM
| |||
| |||
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?
|
#2
3rd December 2015, 05:32 PM
| |||
| |||
Re: Informatica BI Tool
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 |
|