Critical Performance Factors

The ETL process has four areas that will affect performance:

  1. Pulling data between servers.
  2. Managing the updates of the component databases.
  3. Performing PL/SQL and direct SQL transformation operations on the database server.
  4. Project management data dimension and fact table generations.

In This Section

Pulling Data between Servers

Merging Updates into Target Database

PL/SQL-based Transformations


Last Published Tuesday, December 20, 2022