I am a functional consultant and wanted to know how difficult it is to do the following and what is the procedure. I want to know this for my understanding.
I have a requirement to extract deltas frequently from WLK1 table ( IS- Retail).
In WLK1 i do not have the time stamp field, I just have a last change date.
I have two ideas- Please let me know which one would be better in terms of simplicity and performance.
1) I want to add a time stamp field to WLK1 by telling my developer to enhance the table and considering all the programs associated with the table when the table is updated. in this way I will have a reference time stamp field directly and i can extract the deltas.
2) without any development, I can consider the change document tables- CDHDR, CDPOS for the changes(for object class) and based on that i can define the extract logic of deltas. The problem i see with this method is CDHDR is taking lot of time to get the records with in a time frame, so it will certainly affect the performance of the extract program.
My inclination is towards option 1, but I am not sure, how big of a task is that and what is the procedure that is normally adopted.
Any advice would be appreciated <removed by moderator>.
Thanks & Regards,
Edited by: Thomas Zloch on Sep 20, 2011 11:59 PM