transform map roll back mechanism

[tryme]

I haven't seen any roll back mechanism if the data is import to the target table incorrectly.

Actually I want a function like transaction in the sql. We can see the data in the table before commit.

But seems there is none. Is there any place I have missed? If not, can we work that out easily?

Is there any concept of transaction in servicenow I mean.

[Geoffrey2]

There is currently no such functionality out-of-the-box. There is no roll-back functionality for Transforms.

The Target records are not matched to the Import Set Rows until you run the transform, so there is no way to compare the data before commit.

You would need to build some custom functionality for this.

But it is a good idea though.   Maybe you should log an Enhancement Request on Hi.

[Kalaiarasan Pus · Accepted solution]

'Test load of records' link is the only thing OOB for testing data import before the actual commit.

But once the data is committed, we can just filter out the recently updated records using the UI on the target table.(Updated before 15 mins or something similar)