IRI FACT (Fast Extract)

Available from IRI, The CoSort Company

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

Rating: 0 - 0 reviews
Let users know what you would have wanted to know about this company.
Click on a star to rate this company
Post anonymously
When writing a review, please adhere to the Review Guidelines.