topic Parallel processing in SAS Data Integration Studio (ETL) in SAS Enterprise Guide

Parallel processing in SAS Data Integration Studio (ETL)

deleted_user — Mon, 21 Apr 2008 15:58:02 GMT

Hi All, I am new to SAS DI studio. I wanted to know if we can run the 2 jobs at the same time both of which inserts/updates the same target table.
In short:
1) Is it possible in SAS DIS to run 2 jobs at the same time.
2) If yes, then in above mentioned scenario, while updating the same target table will there be any locking or resource access problem...

any help or guide in this case would be highly appreciated.

regards
Kapil Agrawal, India

Re: Parallel processing in SAS Data Integration Studio (ETL)

Cynthia_sas — Mon, 21 Apr 2008 16:39:15 GMT

Hi:
Since this is the SAS Enterprise Guide forum, and since the question is more platform/configuration/DI Studio specific, your best bet is to contact Tech Support. They can look at your particular configuration and your installation and help you find the best way to do your updates.

cynthia

Re: Parallel processing in SAS Data Integration Studio (ETL)

deleted_user — Tue, 22 Apr 2008 04:01:28 GMT

Thanks a lot 🙂

Re: Parallel processing in SAS Data Integration Studio (ETL)

tbatliner — Tue, 22 Apr 2008 08:44:19 GMT

Hi,

as far as I know this is not possible (except if you have a SAS/SHARE Server running). SAS requires an exclusive lock on the affected tables...

hope that helps,
Thomas