What table acts as a staging area for records imported from a data source?

When data is imported into ServiceNow from an external data source, it is not loaded directly into the target table. Instead, the platform first places the raw data into a temporary table that acts as a staging area. This table is technically an "Import Set Row" table, which extends the base sysimportsetrow table. Each import process creates a new table with a unique name (e.g., uimp...) for this purpose. This staging process allows for data to be validated and transformed via a Transform Map before being committed to its final destination table, ensuring data integrity.

A. Transform Table: This is not a standard ServiceNow term. The related component is a "Transform Map," which defines field mappings, not a table.
B. Staging Table: While this is a conceptually correct generic term, "Import Set Row Table" is the more specific and technically accurate name used within the ServiceNow platform.
D. Temp Table: This is a generic database term. ServiceNow uses the specific "Import Set Row Table" terminology for its import staging process.

1. ServiceNow Product Documentation - Import Sets: "The Import Set table acts as a staging area for records imported from a data source." This document clarifies the role of the staging table in the import process. (ServiceNow, Import Sets, Doc ID: KB0719038, Section: "Import Set Process").

2. ServiceNow Product Documentation - Import set tables: "When a new import set is created, the system creates a table to store the imported data... This table is referred to as the import set table or staging table. All import set tables extend the Import Set Row [sysimportsetrow] table." This reference confirms the table's name, purpose, and its extension from the sysimportsetrow base table. (ServiceNow, Import set tables, Doc ID: 1119811).

3. ServiceNow Developer Portal - Import Sets Concepts: "Data is imported into a staging table... A transform map provides a guide for moving data from the staging table to a target table." (ServiceNow Developer Program, Import Sets, Section: "Import Set Concepts").