ETL : Data Extraction - Pointers

Extract, Transform and Load (ETL) refers to three separate functions combined into a single programming tool. First, the extract function reads data from a specified source database and extracts a desired subset of data. Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - to convert it to the desired state. Finally, the load function is used to write the resulting data which can be used for further reporting or analysis.

Also take a look at the 3 Common Issues of Data Warehouse project. Its important to engage the right consultant to help you Pre plan, Analyse, and Implement the Data Warehouse Solution with reduced effort and disruption to users. Contact us to know more about Data Warehouse and how it can benefit your organisation. Thanks for dropping by and Have a fantastic day!

Best
Srivats

Srivatsan Aravamudan

Design and Communication

PsiberTech Solutions Private Ltd

Twitter 

Google plus
LinkedIn