Question:
I am having data of last 10 years in ods . but our requirement is only to have last 2 years data in ods.Is there any solution?its urgent if anyone has any idea about it please let me now.
Regards
Rajesh
Answer:
Hi!
Depending on the time characterstic u delete the last 8 years of data .
use selective deletion technique( RSA1-->MANAGE-->SELECTION).
in this u select the 8 years on fiscyear and then press delete.
thanks & Regards
SUdheer K.V
Answer:
Thanks a lot for good suggestion it has solved my problem but i am doing delta upload the data is changing then i have to delete data daily is there any other solution so that there is no need to delete data daily.
Regards
Rajesh
Answer:
you can schedule this selective deletion as a daily job ...