With data cleanup progressing nicely, we've picked a date to begin our third conversion test. We will start on May 6 and hope to be finished in a week or so.
Our number one goal for conversion 3 is to bring every bit of Benefactor data over. "No record left behind" is our new motto! This means that any errors encountered will need to be fixed in bentest as well as in benlive, and possibly also in production and the conversion environment. We don't expect to receive many errors, but if we do this could slow us down some.
Our second goal is to bring the demographic data over properly. Some of the addresses - particularly the N1 (Other Addresses) - came over in conversion 2, but not the way we had planned. This was due to our solution for address ambiguities. We've been studying the converted data and re-evaluating our method of dealing with address ambiguities at L1, N1, and N2. Combined with this work and the data cleanup we've been doing we expect both fewer address ambiguities and better results from our computed columns in the third conversion.
And our final goal is to develop a plan for running the live conversion. We won't run it as a mimic of the live conversion - that is, we won't be doing it over a weekend on a quiet system, working through nights - but we will try to determine the best way to split up the conversions for maximum efficiency.