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

[Amitra Bhunia]

Instead of of using Transform map , After BR will increase the execution load I think.

[Yogi3]

Yes, you can achieve this by leveraging onStart or onBefore transform map scripts. onStart runs only once at the start of transform OnBefore runs for each record in the import set table before transforming each record. Hope this helps! -Yogi

[Aishwarya Thaku]

Hi @Amitra Bhunia ,

You can use onStart Transform Script to achieve this as the onStart event script is processed at the start of an import run before any data rows are read and then other scripts execute. The sequence of execution is like - 

1. onStart script

2. For each imported row -

i. Field mapping for coalesce fields

ii. onBefore script

iii. Field mapping for non-coalesce fields

iv. Transform map script (when Run Script Checkbox is true)

v. Insert/Update takes place in database

vi. onAfter script

3. onComplete script

'

Hope it helps!

Please mark it as helpful or correct if applicable.

Thanks,

Aishwarya