FACT TOOL

Fact is a fast data extraction tool used for load data in Oracle and DB2 tables:

  • High volume data loading for ETL and Data base reorganizacion.
  • Huge tables data extraction for data base migration.
  • Replication between source tables and plain text files.
  • Interacts with Cosort to generates metadata and heavy data load with SQL*Loader.

FACT advantages

Fact Permits both, ETL users and DBAs load and reload tables fastest and handiest than other tools and products, inclusive SQL*Loader and Oracle export utility.

SQL*Plus was designed for management of small Oracle data sets, therefore when it tries to deal with big data loads the response time dramatically decreases; thus, FACT is the solution.

Fact is 5 to 7 times faster in data processing depending the used hardware.

Processes combined simultaneously on ETL:

  • Sorting
  • Merging
  • Appending
  • Data Type Conversion
  • Calculations
  • Reporting

FACT using SORTCL and SQLLDR is 5 to 7 times faster that Oracle INSERT.

FACT and business benefits

  • Increases data availability for Business Intelligence.
  • Holds a Warranty of free operation errors SLA (Service Level Agreement).
  • Minimizes Software and Hardware updation spents
  • Enhances speed and frame time of data migration for CRM, ERP and SCM.
  • Frees staff from management of large data volumes.

COSORT and FACT combination achieves great performance, data manipulation and management,as illustrated below.