10-19-2017 11:02 AM
I have a SAS DI job which takes a bunch of tables from Oracle, pushes down the join criteria before it hits a table loader which directs the dataset into SAS.
The join operation completes very quickly, according to the Stats tab in 1 second and returns 7,931 records but the table loader has been processing for nearly two hours.
Options on the table loader are as follows:
Load Style: Replace
Replace: Entire Table
New Rows: Append (Proc Append)
Is there anyway I can work out why this transformation is taking so long? Is it possible to view the process in SAS management studio at all?
10-21-2017 06:17 PM