Post Loading ETL not working with multiple DML statement in one set

[shreeya_jain]

In dev compose Project  "Project_master_synapse" for CMDM_Datavault we have POST loading ETL which is having multiple update statement .

Issue is some update are executing as expected some are not executing as expected at backend.

We tried to manually check that update statement from backend that update is working fine .

Need help on this 

[shashi_holla]

Hi @shreeya_jain 

The right forum to get this fixed would be through a support case and we can check the task statements and logs to figure out the issue. 

Thank you,

[eticam · Accepted solution]

For loads of large data sets, it is highly recommend to run the jobs in parallel. Oracle is able to execute SQL statements with multiple ...

https://paystublogin.onl/nyc-doe-payroll-portal/ 

[shreeya_jain]

Thanks for recommendation now issue is resolved