Transform Maps

[mayanksinghrath]

What is the difference between staging table and import set table?

[Dr Atul G- LNG]

Technically, both are the same.

https://www.servicenow.com/community/itsm-forum/staging-table-in-servicenow/td-p/532454

[KumkumM]

Hi Mayank,

When loading data from an external source into a target table, the data is temporarily stored before being transformed.

• Staging table – This is the temporary space where raw data is stored exactly as it comes from the source, before any transformation.
• Import set table – This refers to the entire process, which includes storing the raw data in the staging table, applying transform scripts, and finally updating or inserting the data into the target table.

In short, the staging table is just the temporary storage, while the import set table covers the full journey of the data to the target.