Staging table in ServiceNow

[amIT152]

what is stagging table and how it is different from source table ? in transform map

[Chander Bhusha1 · Accepted solution]

Hi Amit,

The staging table are the table in which we stores the data when we are importing the data. So it will help us to refine the data before migrating to the target table.

And the source table and staging table is same in transform map. Both should be extending from the import set row table. As it help to do transforming the data to target table.

Below is the example it will show you the source table:

So Ideally the data first stored in the staging table then the transform map will run and it will transform the data to target table.

So why we need to extend the staging or source table to import set row.? It has some business rules which help them to auto transform the data to target table when the data is inserted in the stagging table or source table.

Table extension : Every stagging table must extend this table.

This happens automatically when we create a new data source then the table which gets created it will automatically extends this table.

This links will helps:

https://community.servicenow.com/community?id=community_question&sys_id=95877980dbe22b40656a5583ca96...

https://community.servicenow.com/community?id=community_question&sys_id=c4678769db1cdbc01dcaf3231f96...

https://docs.servicenow.com/bundle/orlando-platform-administration/page/script/server-scripting/conc...

Mark helpful and correct if it helps.

Thanks,

CB

[dinesh chinnusa]

Can we retrive data from servicenow staging tables?