We have requirement to identify Expired/About to expire Partitions [PPI] On Teradata V14.0 to prevent our batch jobs from failing.
So please help me out to figure out this issue.
Maybe this can help you:
Thanks for the post, but am looking for help where SQL can extend the existing PPI's based on currendate to avoid patition violation failures in daily batch jobs.
Please shed some light on this...
As per you suggestion , am trying to run below query to figure out the MAXimum PPI DATE for given table, in this case "2009-06-30" as per below ConstraintText..
|Current Answer-Set||Expected Answer-set|
| ((RANGE_N(Calendar_Date |
So please shed some light to keep me posted to remove non DATE data, so i can only get DATE [format DD-MM-YYYY] data out of token column as shown above.
Thanks in Advance.