1.Are the Changelog tables and the RSMONICDP tables related in any way?
2.Should the number of records in a changelog table match with the number of records in the RSMONICDP table for a particular request id?
3.Is the RSMONICDP the correct table for checking the number of records existing in the changelog table loaded before a timestamp. Eg: UTC(20.061.231.999.999) i.e all requests/records loaded before 12/31/2006.
What re the kinds of tests done before and after change log deletions in production?
Regards,
Tanya