A fast extract step can be a critical component of:
- database archive and replication
- database reorgs and migrations
- data warehouse ETL, ELT and ODS operations
- offline reporting and bulk data protection
IRI's Fast Extract (FACT™) utility is a parallel unload program for very large database (VLDB) tables in:
- DB2 UDB
- SQL Server
that rapidly creates portable flat files.
FACT also creates the extract's layout metadata in the formats for CoSort SortCL data definition files (.DDF) and bulk database load utility configuration files. This helps you process the extracts in CoSort, and/or re-load them (pre-sorted) to the same or different database.
Piping these operations together speeds ETL and reorg operations even further. Don't just meet SLA requirements. Meet the scalability demands of big data.