Can I delay the execution of Transform Map

[Amitra Bhunia]

Hi All,

I am trying to create a transform map where I want to run the transformation after some processing in staging table. After the processing (Using some async BR) I will Update the status in staging table and then the transformation  should begin to create or update data in target table.

Is it possible to achieve this?

Regards,

Amitra

[Maik Skoddow]

Hi @Amitra Bhunia 

it is extremely unusual to run custom BRs on the staging table and can lead to unexpected behavior. If you have any general transformations which have to be done before, you can use before-Scripts (for the complete import, but also on row level).

Please see https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_le... for more information

Kind regards
Maik

[Amitra Bhunia]

Hi Maik,,

A before transform script is synchronous process. I want to avoid the synchronous and make the code execution Asynchronous. Thats why I want to run the transform after the BR Execution and to avoid the before BR.

Regards,

Amitra

[Maik Skoddow]

Sorry, but that makes no sense to me. Waiting for the completion of an asynchronous BR has the same effect as a synchronous approach.

You should provide more details otherwise I cannot help.

Kind regards
Maik

[Sajilal]

OOTB there is no way to achieve this but you can think of After Business rules on your Import Set table only.

Please mark helpful/correct if it helped resolve your query.

Thanks,
Saji