Staging table -> transfrom map -> custom table

maxpawan2
Tera Contributor

Hi Team,

 

Scenario - Pull data via schedule jobs from source systems & load to one target custom(alert) table in one generic format.

Finally utilize BR to create incident.

 

Solution approach -

  • Schedule job to pull data
  • save data to import set staging table
  • use transform map
  • to finally maintain all data to custom table
  • Async BR to create incident.

Query :- Does transform map execute automatically when a new record get inserted into staging table.

 

Thanks for your advice & support.

 

#transformmaps

1 ACCEPTED SOLUTION

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

To answer your question: Yes.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

1 REPLY 1

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

To answer your question: Yes.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn