Staging Table

Swarnika1
Tera Expert

Can anyone please tell me What is Staging Table? How it this useful in servicenow.

1 ACCEPTED SOLUTION

Omkar Mone
Mega Sage

Hi 

When you want to import data from some external file(excel,xml,json) etc then there is way of importing it in servicenow. 

It is done through import set and transform maps. So basically when you import data it get's stored in a new table which we call it as a staging table. We call it as a staging table because before getting into the main table in servicenow, if we want to make changes and map fields here in servicenow to those that came from external source, staging table is used in transform maps. 

Please check the below link for more info :-

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/refere...

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concep...

 

Regards,

Omkar Mone.

www.dxsherpa.com

View solution in original post

3 REPLIES 3

Omkar Mone
Mega Sage

Hi 

When you want to import data from some external file(excel,xml,json) etc then there is way of importing it in servicenow. 

It is done through import set and transform maps. So basically when you import data it get's stored in a new table which we call it as a staging table. We call it as a staging table because before getting into the main table in servicenow, if we want to make changes and map fields here in servicenow to those that came from external source, staging table is used in transform maps. 

Please check the below link for more info :-

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/refere...

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concep...

 

Regards,

Omkar Mone.

www.dxsherpa.com

Thanks. It was helpful 🙂