Loading into sas database taking longer

[cherishma]

Hi Buddies,

I am trying to load data from oracle db table into sas . But the load time is really huge. Please could any one suggest a better load procedure to save the time.

loading an oracle  table (25 million record)====> SAS db

Cheers! 

[Anonymous]

Hello,

Performance issue usually cause by the DB connection or the job design, could you upload some screenshots of your job? Please mask your sensitive data.

Best regards

Sabrina

[cherishma]

Hi Sabrina,         

It is just simple loading from oracle db toSAS.

Data: 25 million records.

Please could you help me with a better solution for quicker load???...         

Also please could you let know how do we update records in sas using tsasoutput??

Thanks ! 

sas_load.JPG