Desktop productivity for business analysts and programmers

Parallel processing in SAS Data Integration Studio (ETL)

Reply
N/A
Posts: 0

Parallel processing in SAS Data Integration Studio (ETL)

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
SAS Super FREQ
Posts: 8,721

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

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
N/A
Posts: 0

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

Thanks a lot Smiley Happy
Contributor
Posts: 30

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

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
Ask a Question
Discussion stats
  • 3 replies
  • 135 views
  • 0 likes
  • 3 in conversation