Use this parameter to limit the age of events that get copied into the data warehouse. The parameter specifies a timestamp. Only events captured on or after this date are copied into the data warehouse. Events captured before this date are excluded and not copied to the data warehouse.
Always enclose the timestamp in single quotes.
@No_Older_Than_Date='timestamp'
Dates are always in this format: yyyy-mm-dd hh:mm:ss.
No_Older_Than_Date=>to_date('timestamp','pattern')
Defines the timestamp format by a pattern, such as 'DDMMYYYY' or 'YYYYMMDD HH24:MI:SS'.
These examples specify 4 July 2012 6:00 am:
@No_Older_Than_Date='2012-07-04 06:00:00'
No_Older_Than_Date=>to_date('20120704 06:00:00','YYYYMMDD HH24:MI:SS')
If you specify a new timestamp, the purge parameter defaults to 0 (zero).
|
Copyright © 2012 CA.
All rights reserved.
|
|