Dear Team,
I have created a batch data job which is taking 10 hours to read having 3 crores of Rows. Please suggest how to improve the performance in SAS Data Management Server ?
I have attached one screenshot for your references. it may be taking long time to read the data from ORACLE db.
Let me know if required any further details
Thank You
Shakti
Have you tried running just reading of Oracle part? I suggest you make a copy of your job and delete all except the first four tasks - up to Data Union 1. Then test how long that takes. Your job will not be any faster than how long it takes to read your data.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.