Effectively capturing, managing and using row data to originate meaningful Business Intelligence
(BI) is requirement for enterprises today. The data can be reside in different places with different formats. So successfully guide present and future decisions all level of management must have control over this data, which is a big challenge. To achieve this goal modern industry uses a process called ‘Data Integration
’.
(BI) is requirement for enterprises today. The data can be reside in different places with different formats. So successfully guide present and future decisions all level of management must have control over this data, which is a big challenge. To achieve this goal modern industry uses a process called ‘Data Integration’.What is ETL?
ETL
means Extract Transform and Load. Extracting data from outside source, transforming them to fit operational needs, loading them into the targeted destination. ETL is the core process of Data Integration. It is generally associated with data warehousing.
means Extract Transform and Load. Extracting data from outside source, transforming them to fit operational needs, loading them into the targeted destination. ETL is the core process of Data Integration. It is generally associated with data warehousing.Extraction:
Sources:
* Relational Databases
* Excel files
* Flat files
* etc
Transformation:
In the transformation process applies a series of business rules or functions to the extracted data from the source to make the data for loading into the target destination.
Load:
Destinations:
* Data warehouses
* Excel files
* Flat files
* etc
and 
.
No comments:
Post a Comment