The ETL process has four areas that will affect performance:
- Pulling data between servers.
- Managing the updates of the component databases.
- Performing PL/SQL and direct SQL transformation operations on the database server.
- Project management data dimension and fact table generations.