To run the Transform map sequentially

[snehalkhare]

Hi All,

I have a script to run the transform on the staging tables , but I want to run the transform maps in such a manner that a particular transform runs first , the second should run only when the first transform is completed and so on . How to achieve this?

Regards,

Snehal Khare 

[Kamal17]

Hi,

1. If all your transform maps belong to same data source,

In this case, open your Data Source record and then you can use the order field in the transform map related list to specify your order.

2. If all your transform maps belong to different data sources,

In this case, you can try creating Scheduled Data Imports where you can specify 'Parent' for each job. This will ensure that your transform maps execute sequentially.

Mark Correct if this solves your issue. Hit Like/Helpful based on the impact.

Regards,

Udhay

[Ashutosh Munot1]

HI,

So you have transform maps on same target table or different target table.

Thanks,
Ashutosh

[snehalkhare]

Different target tables.

Regards,

Snehal

[Ashutosh Munot1]

HI,

Then Create A schedule Data import and use give one parent. After the parent completes the child will be triggered and that too in sequential manner, this manner is decided by order.

see below screen shot:

Thanks,
Ashutosh Munot