Transform Map execution

[Tejas Adhalrao]

Question 1:
If data comes from an API and is inserted/updated in a staging (Import Set) table, when will the Transform Map execute? If multiple Transform Maps are associated with the same staging table, will all of them execute?

Question 2:
When using Easy Import, a separate staging table and Transform Map seem to be created for each import/user. Is there a way to use a common staging table and Transform Map, and how can we add import validation?

[Sanjay191]

Hi @Tejas Adhalrao 

Answer 1:
As soon as the data records are inserted into the associated Staging Table or Import Set Table.

Answer 2:
You can create the required fields in the Staging Table and map those fields to the corresponding fields in the Target Table. Make sure all the required fields are available in the Staging Table. Then, select the same Staging Table as the Source Table in the Transform Map.

If you found my response helpful and it answered your question, please consider marking it as the accepted solution and giving it a thumbs up. It helps others in the community find the solution more easily.

Thank you!

[Dr Atul - LNG]

Hi @Tejas Adhalrao 

Have a look

https://youtu.be/xMNjWrIC0ys

[Tejas Adhalrao]

hi @Dr Atul - LNG ,

I watched your video, and the way you explained everything was really great!

but my  question is 

https://www.servicenow.com/community/developer-forum/questions-regarding-import-set-transform-map-ex...

[Dr Atul - LNG]

So you can close this thread budy,