We are planning to make a Datawarehouse. For this the RAW data can imported from Flat Files, OLTP, XML data files etc etc.....and processed using ETL and then inserted onto DW.
Now suppose I need to archive datawarewouse every 2 months. that means on archiving, data for the last two months will be MOVED from the original location to some other location.
Then how can we determine while ETL process that the particular data has been archived and should not be imported again.?
I think this is a general issue and should have a standard solution.