Planning for ETL solution By: Basit A. Farooq Introduction Because any business intelligence (BI) mainly deals with the data, without doubt, the solution includes an extraction, transformation and loading (ETL) components linking the data sources and destinations. After gathering business requirements, the first step in the ETL component design is to plan the data transfer and staging solutions that support...