Question:
Hi Guys,
I have a ODS in Production that has three years of data (2003,2004 and 2005).Data is loaded weekly.
My question is Can i not delete a Request that is way back in 04/2003??
When i try to delete that request, it says , there are active requests that are to be deleted before this request.
Only full loads are done to this ODS.
Shuold I delete the requests from the Top?
Please let me know.
Answer:
You mean, from the bottom? If any request from the middle is deleted, loading the next new data will be a problem as it will keep saying that SIDs are out of sequence, please update the request with the lower SID(the one you deleted), etc.
You could create an ODS for each year, and that could also help you in building what is called a 'Data Warehouse Layer' in BW.
Of course, if you don't want the 2003 information, you could delete the change logs, and then the requests for that particular year.
_________________
Keep smiling