Looking around a little more, I still see millions of rows in stage. A reset didn't clear those. Is there an existing way to clear old years of those?
I suggest setting up additional "Reset Scenario" DM Jobs using a range of Yrs by S#.
- Stage tables are critical to the "Data Integrity" in OS apps.
- The best option is to use new RS Jobs to safely "wipe clean" your apps' many Stage tables in OS.
I'm thinking I may have just misread my own stage tables. I had manually cleared a few years of stage from the most common scenarios before I started using the Reset. As I ran the Reset for more and more scenarios, I expected to see the total rows shrinking. However, I was apparently more thorough in my manual deletes than I realized as there's no data in stage prior to the years I want to keep. (What I suppose this means is I know my data and cleared exactly what needed to be cleared. I just wouldn't have needed to do it if I'd used the Reset first.)
