This content has been marked as final. Show 6 replies
We don't have a concept of delaying in hours. As DAC supports atleast minimum 1 day and that too you need to set it in prune days.
If you want further information plz go through the below link
Navin Kumar Bolla
Edited by: Navin Kumar Bolla on Jul 15, 2011 2:05 AM
Edited by: Navin Kumar Bolla on Jul 15, 2011 2:12 AM
The following steps should work to get LAST REFRESH DATE less than 24 hours. You can also reference metalink note 889803.1:
1) Create a new source system parameter "REFRESH_DATE" as timestamp.
Date Type: Timestamp
Function: Custom format
Format: YYYY-MM-DD HH24:MM:SS
2) Modify $$LAST_EXTRACT_DATE source system parameter properties to:
a) Set the value to SQL
b) In SQL dialog choose DBCONNECTION_OLAP (or any other connection that points to Oracle database) and enter the following string :
to_date('@DAC_REFRESH_DATE', 'YYYY-MM-DD HH24:MI:SS') -numtodsinterval(2,'HOUR') FROM DUAL;
Note: The above SQL is designed to run against Oracle database.
c) Make it custom format YYYY-MM-DD HH24:MM:SS
This will ensure that Last extract date will be refresh date time minus 2 hours.