Oracle Reader

About Oracle

Oracle is a powerful, enterprise-grade relational database management system (RDBMS) developed by Oracle Corporation. It supports SQL, PL/SQL, and advanced features like clustering, replication, and high availability. Oracle is widely used in large organizations for managing mission-critical data and applications.

Properties

Tip: To change Reader properties double click on it.

Count Number of Records

When user run a transformation, software displays a progress bar and completion percentage.

To calculate this percentage, the software must first determine the total number of records in the source table.This record-counting operation can take a significant amount of time, especially for large tables, and may negatively impact overall performance.

Disabling Count Number of Records prevents the software from counting the records before processing begins, allowing the transformation to start immediately and potentially improving performance.