IRI FACT (FAst extraCT) is a high performance database unload utility for Oracle, DB2 UDB, SQL Server, Sybase ASE and IQ, MySQL, Altibase, Greenplum, Teradata, and Tibero.
FACT unloads large tables in parallel to flat files (or pipes). FACT uses SQL SELECT syntax for convenience, and native RDBMS APIs for performance.
While extracting, FACT also writes the data definition file (.DDF) metadata for IRI tools like CoSort and FieldShield so it is easy to pre-sort, encrypt, reformat, test, and report in the flat-file environment. FACT also writes the RDBMS load utility metadata for (re)load operations.
FACT is ideal for:
• very large database (VLDB) offline (external) reorgs requiring unload, sort, and reload
• data warehouse ETL operations
• archive and retrieval
• database migration and replication
• offline reporting