How is my Transform Map getting triggered automatically?

[vmanojkumar]

Hello all,

I’m new to ServiceNow and working on a Workday integration.

The data from Workday is being inserted into a staging/import set table, and I have a Transform Map configured to move the data to the target table.

The Transform Map seems to be running automatically as soon as the records are inserted into the staging table. However, I have not configured any Scheduled Import, manual transform, Flow, or other explicit trigger.

A few additional details:

1. The staging table and target table are available under the same application/module.

2. The records are inserted into the staging table successfully.

3. The Transform Map appears to process the records immediately afterward.

4. I would like to identify exactly what is initiating the transformation rather than simply knowing that the transformation is occurring.

Could someone please help me understand how the Transform Map is being triggered automatically and where I can check what is initiating the transformation?

Thanks!

[Ankur Bawiskar]

@vmanojkumar 

it's out of the box behavior, whenever new record is inserted into staging table it kicks in the Transform map associated with that staging table

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[vmanojkumar]

This is not noticed on the other Import Set tables (staging tables), where I have to manually run the Transform after the Import Set has finished loading.

How can I make the transformation happen automatically for this table?

Also, is there a way to restrict the transformation of records to the target table until the Import Set has completely finished loading into the staging table?

The issue here is that I have an onComplete script that performs some calculations. Since the records are currently being processed simultaneously while they are being loaded into the staging table, the integration is taking a long time to complete.

Ideally, I would like the Import Set to first finish loading all the records into the staging table, set the Import Set state to Loaded, and then trigger the Transform Map. This would allow the transformation and the onComplete processing to happen only after the entire Import Set has been loaded and would help improve the integration performance.

[jasonutah]

It depends on how you are ingesting the data. The process is slightly different between data source scheduled Import or a REST web service API.

For data source and scheduled import make sure you have a scheduled import record with a data source attached. Set execute to run on your schedule. Under the scheduled import record, link your transform map. You should do this because scheduled imports are designed to pull the entire file or dataset into the staging table. Once all of the rows are loaded and the import set state is loaded, ServiceNow triggers the import set transformer job.

This will automatically run your transform map and your onComplete script after all of the rows are loaded.

[vmanojkumar]

@jasonutah ,

I’m not using a Data Source with a Scheduled Import in this case.

Currently, I have two integrations in place with Workday:

1. WQL integration – The data is retrieved from Workday using a WQL query and then inserted into the ServiceNow staging table.

2. RaaS API integration – Workday exposes a RaaS API, through which I receive the data and insert it into the staging table.

So, in both cases, the data is being inserted into the staging table through the integration itself, rather than through a scheduled import.

What I’m trying to understand is what is triggering the Transform Map automatically after the records are inserted into the staging table, since I have not configured a Scheduled Import or any manual transform process.