Good evening to you guys.
I am looking for some expert advice on a task i have:
I have an ODS with two key fields: OrderID and OrderPeriodID.
What we basically do is extract Orders from a legacy system (SQL Server 2000) using DB connect and store it in BW. This is done twice a month. Every Order is loaded into that ODS and given its OrderPeriodID.After loading the ODS we load the data into an Infocube.
My requirement is to be able to deduce what Orders were added to the system between the last period and the current period.
Can you provide any hints on a way to do it? Any methods are welcome, but due to flexibility issues i would rather concentrate on solutions that do not involve manipulating the data in the source system.