IRI FACT (Fast Extract)

Available from IRI, The CoSort Company
Product Menu
View Company Profile View all Products

Product Details

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

Rate and Review IRI, The CoSort Company - IRI FACT (Fast Extract)

No reviews yet.

Let users know what you would have wanted to know about this company.