06-27-2012 09:32 AM
Is this just an information or do you want to ask something?
If this is a question then you would need to give us MUCH more information (eg. SAS and DIS version and OS, what changed, the before and after logs as attachment if possible, the volumes, target table SAS or a DB, ...).
Just as general comments:
- If the previous run was an initial load but now it's a consecutive load then the difference in time can be substantial.
- Depending on the DIS version a lot of tweaking can be done (eg. maintaining a permanent XREF table - especially important when loading into a DBMS).
- DB settings like insert buffers.
06-27-2012 10:13 AM
No i want to know the cause of this problem.
-SAS version: 9.2
-DIS version: 4.21
-target table: ORACLE
-the both previous run and this run are a consecutive load.
-all parameters aren't changed after the previous run.
06-27-2012 12:37 PM
Then start analyzing the 2 SAS Logs and determine where the main differences are (number of rows, timing).
Without analyzing the logs there will be no answer - and you haven't posted the logs here in this forum yet.