Data warehousing is a technology that aggregates structured data from one or more sources so that it can be compared and analyzed for greater business intelligence.
Saturday, 18 March 2017
What is Data Mining?
Data Mining is defined as the procedure of extracting information from huge sets of data.
List of ETL tools
- Informatica PowerCenter
- Oracle Warehouse Builder (OWB)
- SAP Data Services
- IBM Infosphere Information Server
- SAS Data Management
- PowerCenter Informatica
- Elixir Repertoire for Data ETL
- Data Migrator (IBI)
- SQL Server Integration Services (SSIS)
- Talend Studio for Data Integration
- Sagent Data Flow
- Pervasive Data Integrator
- Open Text Integration Center
- Oracle Data Integrator (ODI)
- Cognos Data Manager
- CloverETL
- Centerprise Data Integrator
- IBM Infosphere Warehouse Edition
- Pentaho Data Integration
- Adeptia Integration Server
- Syncsort DMX
- QlikView Expressor
- Relational Junction ETL Manager (Sesame Software)
What is ETL and its process?
ETL - Extract Transform Load
1) Extracting the data from various sources.
2) Transforming the data based on the requirements.
3) Loading the transformed data into destinations.
1) Extracting the data from various sources.
2) Transforming the data based on the requirements.
3) Loading the transformed data into destinations.
Subscribe to:
Comments (Atom)