Advantages / Uses of ETL
- Data-warehouse population - ETL tool can be used to populate the dimensions & fact tables of a data-warehouse - Data migration - ETL tool can be used to migrate or transfer the data between variety of sources like databases, CRMs, cloud, files, emails etc. - Transferring huge data - ETL tools are used to benefit in the transfer rate as they benefit from different technologies like parallel processing, selective processing, etc. - Data cleansing- ETL tool can be used to cleanse your data i.e. remove any inconsistent or ambiguous data - Source for reports & analysis - ETL readies the data for further representation in the data warehouse in the form of reports or analysis. - Big data support - ETL tool supports many big data options such as Hadoop, etc.