Meta tags:
keywords=fast extract, db unload, fact specs, fast unload information;
description=IRI FACT (Fast Extract) technical details. Learn more about the parallel unload product for Very Large Databases like Oracle from IRI, The CoSort Company.;

Headings (most frequently used words):

iri, on, take, closer, look, at, fact, rapidly, unload, oracle, and, other, vldbs, try, software, site, free, for, 30, days, request, more, information, follow, us, get, the, newsletter, quick, links, solutions, products, customers, services, company, support, news, partners,

Text of the page (most frequently used words):
data (154), iri (89), gui (63), faqs (41), fact (41), technical (35), masking (35), resources (32), details (32), test (31), certification (31), overview (31), etl (30), why (29), better (29), platforms (29), pricing (29), features (29), benefits (29), metadata (27), the (25), and (25), cellshield (22), cosort (21), voracity (20), darkshield (17), fieldshield (17), rowgen (17), nextform (17), manager (17), sort (17), sortcl (17), support (16), migration (16), big (16), free (15), trial (15), file (13), management (13), workbench (12), database (12), with (11), services (11), user (11), tools (11), platform (11), for (10), quote (10), demo (10), training (10), transformation (10), suite (10), files (10), your (9), request (9), contact (9), conversion (9), sql (9), discover (9), extraction (8), operations (8), use (8), live (7), self (7), learning (7), history (7), legacy (7), mdm (7), integration (7), share (7), create (7), can (7), program (7), oracle (7), run (7), cobol (7), product (6), reports (6), unload (6), other (6), replication (6), eclipse (6), that (6), also (6), fast (6), convert (6), edit (6), design (6), cloud (6), compliance (6), quality (6), master (6), type (6), newsletters (5), legal (5), international (5), dark (5), excel (5), ripcurrent (5), protector (5), products (5), this (5), table (5), format (5), transforms (5), performance (5), protection (5), reporting (5), select (5), you (5), apis (5), matrix (5), jobs (5), get (4), software (4), site (4), copyright (4), embed (4), opportunities (4), resellers (4), industry (4), alliances (4), expert (4), consultants (4), partners (4), press (4), releases (4), news (4), license (4), transfers (4), education (4), center (4), notices (4), careers (4), about (4), company (4), professional (4), payment (4), portal (4), webinars (4), surveys (4), groups (4), roles (4), testimonials (4), case (4), studies (4), industries (4), customers (4), replacements (4), governance (4), analytics (4), solutions (4), load (4), flat (4), structured (4), solution (4), ini_file (4), reorg (4), security (4), time (4), custom (4), speed (4), feature (4), facilities (4), projects (4), sources (4), personal (4), edition (4), add (4), jcl (4), plugins (4), any (3), chat (3), not (3), column (3), warehouse (3), pre (3), control (3), from (3), including (3), parallel (3), command (3), perform (3), sorting (3), scl (3), loader (3), uses (3), creates (3), through (3), formatting (3), extract (3), privacy (3), policy (3), code (3), conduct (3), disclaimer (3), trademarks (3), internships (3), engineer (3), developer (3), marketing (3), channel (3), account (3), 2020s (3), 2010s (3), 2000s (3), 1990s (3), 1980s (3), 1970s (3), recognition (3), outreach (3), mission (3), location (3), differentiation (3), directed (3), review (3), needs (3), qualifiers (3), programmer (3), isv (3), officer (3), architect (3), cio (3), dba (3), analyst (3), scientist (3), transport (3), telco (3), cable (3), retail (3), cpg (3), healthcare (3), government (3), energy (3), cdi (3), ecommerce (3), bfsi (3), tdaas (3), virtualization (3), devops (3), subsetting (3), benchmarking (3), unikix (3), sas (3), natural (3), micro (3), focus (3), bin (3), teradata (3), sybase (3), server (3), snowflake (3), sap (3), hana (3), postgresql (3), mysql (3), mariadb (3), mongodb (3), db2 (3), cassandra (3), substrings (3), merge (3), filter (3), scrub (3), cleanse (3), map (3), reformat (3), pivot (3), unpivot (3), match (3), join (3), lookup (3), formats (3), keys (3), cross (3), calculate (3), aggregate (3), tdm (3), real (3), dynamic (3), static (3), service (3), pci (3), dss (3), hipaa (3), india (3), dpdp (3), act (3), gdpr (3), ferpa (3), dlp (3), ccmc (3), cpra (3), ccpa (3), auditing (3), beyond (3), easy (3), optimization (3), build (3), new (3), enterprise (3), cobit (3), stewardship (3), rbacs (3), forensics (3), bootcamp (3), iot (3), cases (3), out (3), hadoop (3), semi (3), unstructured (3), provisioning (3), packaging (3), wrangling (3), dashboard (3), splunk (3), integrations (3), knime (3), embedded (3), preparation (3), access (2), newsletter (2), more (2), field (2), does (2), information (2), sorted (2), bulk (2), utilities (2), very (2), large (2), tables (2), simultaneously (2), summary (2), process (2), xml (2), tool (2), much (2), transform (2), spec (2), ddf (2), workflow (2), supported (2), same (2), automatically (2), specification (2), execute (2), pipe (2), unloads (2), processes (2), users (2), configure (2), line (2), invocation (2), character (2), numeric (2), options (2), are (2), faster (2), than (2), using (2), steps (2), once (2), methods (2), testing (2), rapidly (2), query (2), apply (2), rules (2), sorts (2), included, try, days, see, previous, info, sitemap, 2026, innovative, routines, inc, follow, indicates, required, page, generating, safe, encryption, identification, converting, exported, types, roll, ups, delta, loads, produce, formatted, vldb, transaction, fastest, way, outputs, during, well, csv, replicas, web, ready, cube, hand, offs, offers, level, processing, versatility, ease, while, relieving, overhead, initiates, rapid, pipes, will, simultaneous, filtering, aggregation, reformatting, turn, one, output, targets, stdout, dat, piped, index, order, direct, true, ctl, sqlldr, example, operational, template, part, total, designed, executed, ide, job, references, ini, dbas, architects, optionally, complete, offline, integrated, works, via, creation, like, consolidates, entire, into, single, pass, such, row, simple, text, identifies, extracts, specifies, target, destination, built, activities, execution, various, wizards, state, art, diagrams, feed, removal, null, number, casting, varchar, length, displays, packed, decimal, trimming, reduction, delimiter, frame, choices, fixed, variable, record, alignment, date, timestamp, includes, several, useful, layout, benchmarks, show, produced, many, times, plus, odbc, consumes, few, system, require, balancing, second, none, superior, connection, protocols, hints, queries, variety, proprietary, techniques, rate, spool, export, functions, accelerate, all, these, post, but, have, anything, want, them, unlike, pump, portable, dump, thus, quickly, available, purpose, reorgs, migrations, change, external, native, syntax, choice, split, generate, populate, modify, customize, report, federate, replicate, structure, migrate, audit, logs, cli, api, rdb, nosql, pii, discovery, classification, risk, score, pseudonymize, redact, encrypt, profile, connect, explore, dlcm, display, deliver, debug, deploy, develop, define, help, coupon, sortcl_routine, cosort_r, import, sample, logging, function, quick, links, home, next, vldbs, take, closer, look, toggle, navigation, faq, blog,

Text of the page (random words):
ai data preparation embedded bi knime integration splunk integrations cloud dashboard data wrangling big data big data packaging big data protection big data provisioning structured data semi unstructured data with out hadoop use cases iot bootcamp data governance data masking data quality test data forensics rbacs stewardship cobit enterprise metadata management master data management data integration build new etl speed your etl re platform your etl etl performance optimization fast easy iri etl tools etl beyond data masking auditing cpra ccpa ccmc dlp ferpa gdpr india dpdp act hipaa pci dss data masking as a service static data masking dynamic data masking real time data masking test data tdm data migration data type conversion file format conversion database migration data replication data transformation aggregate cross calculate custom transforms formats keys lookup match join pivot unpivot re map reformat scrub cleanse select filter sort merge substrings type convert db operations cassandra db2 mongodb mysql mariadb oracle postgresql sap hana snowflake sql server sybase teradata metadata mdm metadata metadata management master data mdm quality security services sort replacements bin sort jcl sort micro focus cobol natural sas unikix test data benchmarking compliance db test data db subsetting devops test files reports test data virtualization tdaas products iri data manager suite iri data protector suite iri ripcurrent iri voracity platform overview features benefits technical details gui platforms pricing why it s better voracity faqs resources iri cosort transformation overview features benefits technical details gui platforms pricing why it s better cosort faqs resources sortcl program sortcl metadata cobol tools sort plugins apis iri fact extraction overview features benefits technical details gui platforms pricing why it s better fact faqs resources iri nextform migration overview features benefits technical details gui platforms pricing why it s better nextform faqs resources iri rowgen test data overview features benefits technical details gui platforms pricing why it s better rowgen faqs resources iri fieldshield masking overview features benefits technical details gui platforms pricing why it s better fieldshield faqs resources iri cellshield excel cellshield personal edition pe add in cellshield ee cellshield faqs iri darkshield dark data overview features benefits technical details gui platforms pricing why it s better darkshield faqs resources iri workbench gui overview data sources discover data design run jobs edit share projects workbench faqs eclipse facilities voracity gui cosort gui fact gui fieldshield gui darkshield gui nextform gui rowgen gui free trial demo quote feature matrix trial t cs free trial live demo quote request contact customers industries overview bfsi cdi ecommerce energy government healthcare retail cpg telco cable transport case studies testimonials user roles bi analyst data scientist dba overview cio it manager etl solution architect compliance officer programmer isv legacy tools user groups surveys data masking qualifiers it needs user review webinars payment portal services professional services product training iri hq training on site training self directed learning certification certification voracity certification cosort certification fact certification nextform certification fieldshield certification cellshield ee certification darkshield certification rowgen certification technical support company about iri differentiation history location management mission outreach recognition history 1970s 1980s 1990s 2000s 2010s 2020s careers account manager channel manager marketing manager software developer support engineer internships contact us legal notices copyright trademarks disclaimer code of conduct privacy policy faqs support data education center self learning support request license transfers news press releases newsletters partners expert consultants big data cloud dw bi data masking legacy migration test data industry alliances international resellers embed opportunities solutions bi analytics ai ai data preparation embedded bi knime integration splunk integrations cloud dashboard data wrangling big data big data packaging big data protection big data provisioning structured data semi unstructured data with out hadoop use cases iot bootcamp data governance data masking data quality test data forensics rbacs stewardship cobit enterprise metadata management master data management data integration build new etl speed your etl re platform your etl etl performance optimization fast easy iri etl tools etl beyond data masking auditing cpra ccpa ccmc dlp ferpa gdpr india dpdp act hipaa pci dss data masking as a service static data masking dynamic data masking real time data masking test data tdm data migration data type conversion file format conversion database migration data replication data transformation aggregate cross calculate custom transforms formats keys lookup match join pivot unpivot re map reformat scrub cleanse select filter sort merge substrings type convert db operations cassandra db2 mongodb mysql mariadb oracle postgresql sap hana snowflake sql server sybase teradata metadata mdm metadata metadata management master data mdm quality security services sort replacements bin sort jcl sort micro focus cobol natural sas unikix test data benchmarking compliance db test data db subsetting devops test files reports test data virtualization tdaas products iri data manager suite iri data protector suite iri ripcurrent iri voracity platform overview features benefits technical details gui platforms pricing why it s better voracity faqs resources iri cosort transformation overview features benefits technical details gui platforms pricing why it s better cosort faqs resources sortcl program sortcl metadata cobol tools sort plugins apis iri fact extraction overview features benefits technical details gui platforms pricing why it s better fact faqs resources iri nextform migration overview features benefits technical details gui platforms pricing why it s better nextform faqs resources iri rowgen test data overview features benefits technical details gui platforms pricing why it s better rowgen faqs resources iri fieldshield masking overview features benefits technical details gui platforms pricing why it s better fieldshield faqs resources iri cellshield excel cellshield personal edition pe add in cellshield ee cellshield faqs iri darkshield dark data overview features benefits technical details gui platforms pricing why it s better darkshield faqs resources iri workbench gui overview data sources discover data design run jobs edit share projects workbench faqs eclipse facilities voracity gui cosort gui fact gui fieldshield gui darkshield gui nextform gui rowgen gui free trial demo quote feature matrix trial t cs free trial live demo quote request contact customers industries overview bfsi cdi ecommerce energy government healthcare retail cpg telco cable transport case studies testimonials user roles bi analyst data scientist dba overview cio it manager etl solution architect compliance officer programmer isv legacy tools user groups surveys data masking qualifiers it needs user review webinars payment portal services professional services product training iri hq training on site training self directed learning certification certification voracity certification cosort certification fact certification nextform certification fieldshield certification cellshield ee certification darkshield certification rowgen certification technical support company about iri differentiation history location management mission outreach recognition history 1970s 1980s 1990s 2000s 2010s 2020s careers account manager channel manager marketing manager software developer support engineer internships contact us legal notices copyright trademarks disclaimer code of conduct privacy policy faqs support data education center self learning support request license transfers news press releases newsletters partners expert consultants big data cloud dw bi data masking legacy migration test data industry alliances international resellers embed opportunities take a closer look at fact rapidly unload oracle and other vldbs next steps home products iri fact extraction technical details quick links iri data manager suite iri data protector suite iri ripcurrent iri voracity platform features benefits technical details gui platforms pricing why it s better voracity faqs resources iri cosort transformation features benefits technical details gui platforms pricing why it s better cosort faqs resources sortcl program function matrix invocation logging sample uses resources sortcl metadata details uses convert import discover create cobol tools data file migration sorting reporting data masking testing sort plugins etl tool sorts jcl sorts apis cosort_r sortcl_routine test data resources iri fact extraction features benefits technical details gui platforms pricing why it s better fact faqs resources iri nextform migration features benefits technical details gui platforms pricing why it s better nextform faqs resources iri rowgen test data features benefits technical details gui platforms pricing why it s better rowgen faqs resources iri fieldshield masking features benefits technical details gui platforms pricing why it s better fieldshield faqs resources iri cellshield excel cellshield personal edition pe add in cellshield coupon cellshield help cellshield ee cellshield faqs iri darkshield dark data features benefits technical details gui platforms pricing why it s better darkshield faqs resources iri workbench gui data sources discover data design run jobs edit share projects workbench faqs eclipse facilities voracity gui discover define design develop debug deploy display deliver dlcm cosort gui connect explore discover convert metadata design edit run fact gui configure query options execute fieldshield gui profile encrypt redact pseudonymize apply rules edit run share jobs risk score darkshield gui data classification pii discovery file masking nosql db masking rdb masking darkshield cli api audit logs nextform gui convert discover test migrate structure replicate federate report rowgen gui discover metadata apply rules customize modify generate populate free trial demo quote feature matrix trial t cs free trial live demo quote request contact fact overview features benefits technical details gui platforms pricing why it s better faqs resources iri fact fast extract rapidly unloads large tables to external files using db native apis sql select syntax and a choice of split parallel query methods unlike other database unload methods e g oracle data pump fact creates portable flat files your dump table to file data is thus quickly available for any purpose including reorgs transforms pre load sorting migrations change and summary reporting etl replication testing and protection if you also use the iri voracity platform or iri cosort product you can use the sortcl program to perform or accelerate all these post extraction steps at once but you do not have to use sortcl i e once the data are in flat files you can do anything you want with them speed fact s extract performance is second to none using superior connection protocols parallel hints and queries and a variety of other proprietary techniques fact s unload rate is much faster than database spool or export functions benchmarks also show that flat files are produced many times faster through fact than through sql plus or odbc operations fact consumes few system resources and does not require load balancing formatting fact includes several useful file layout options including custom date and timestamp formatting numeric data re alignment fixed or variable record formatting delimiter and frame character choices column trimming with reduction packed decimal to numeric conversion varchar length displays null number casting line feed character removal invocation to unload any supported database run fact from the command line fact ini_file or from the free iri workbench gui built on eclipse workbench users of the iri voracity platform for etl and other data management activities can also configure fact specification and execution through various wizards or state of the art workflow diagrams the ini_file is a simple to use text or xml file that identifies the database extracts with a sql select command and specifies the unload target format and destination pipe or files fact also works with via metadata creation the cosort sortcl data transformation and reporting program and with database load utilities like oracle sql loader this consolidates entire database reorg or data warehouse etl processes into single pass operations such users can also perform reporting replication conversion and row column security operations at the same time integrated reorg and etl operations with fact dbas and data warehouse architects can optionally pipe bulk unloads to complete very fast offline reorg or etl processes execute the fact ini file with a cosort sortcl job specification file scl that references the ddf metadata that fact automatically creates sql loader process that uses the control file metadata that fact also automatically creates or as part of a total etl or reorg workflow designed and executed in the iri voracity platform supported in the same eclipse ide iri workbench for example for oracle the operational template is fact c ini_file fact ini_file sortcl spec transform scl spec fact ddf sqlldr control fact ctl direct true this command initiates a rapid table extraction and pipes it to the cosort sortcl program sortcl will perform simultaneous field filtering sorting aggregation conversion protection reformatting replication and or reporting transform scl in turn one of sortcl s output targets stdout dat can be piped pre sorted in index order to sql loader sortcl can create other outputs during this process as well including structured reports csv table replicas xml files web ready reports bi tool cube hand offs and so on no other etl solution offers this level of parallel processing performance versatility or ease of use while simultaneously relieving the database of so much overhead summary iri fact is the fastest way to simultaneously unload very large database vldb transaction fact tables produce formatted flat files from a table create the control file metadata for database bulk load utilities create iri cosort or voracity etl metadata for data warehouse transforms roll ups delta reports and pre sorted db loads create iri nextform metadata for converting the exported data and file types create iri fieldshield metadata for column encryption de identification and masking create iri rowgen metadata for generating safe test data in the table s format share this page request more information live chat indicates a required field iri does not share your informat...