Extraction, transformation and loading are key concepts within a data migration but are not the only steps, there are many more to consider. DQ Rule Books can remotely migrate your data.DQ Rule Books can assist at any stage of the data migration process.From the initial data profiling to the complex financial reconciliation at the end of the migration, we are able to provide dedicated resources and technologies to ensure the migration goes smoothly.The current state of the data must be evaluated, this will initially involve data profilingto locate and give an initial insight into the health of the data, in the absence of ERD or other data documentation it may be necessary to discover relationships, dependencies, primary keys and the data lineage within the organisations current state. If the legacy data systems are in poor health a data audit may be required here.Once the data has been located and identified, then the pre-transformation stage can begin, an in depth assessment of the data is required with an eye on the future state requirements, this should include data verification and the introduction of generic and future system constraint data quality rules.With the quality of the data now measured it is time to transform and standardise the data (as well as mapping), as well as more complicated procedures like de-duplication, matching (including fuzzy logic) and the identification of golden records to enhance data quality.The post transformation stage will validate the transformation work that has been undertaken, the running of the data verification and the data quality rules should now reveal the data to be 100% across dimension, to ensure that all data is fit for the new target system.When the data is present in the new system DQ Rule Books can provide metadata collection, the population of business glossaries and full reconciliation and audit services.
Below is illustration of the different stages of a data migration.
Please enter your details below and a member of the team will be in contact to discuss your requirements.
You can adjust all of your cookie settings by navigating the tabs on the left hand side.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
3rd Party Cookies
This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Please enable Strictly Necessary Cookies first so that we can save your preferences!
Last updated: May 23, 2018
What are cookies
Cookies are small pieces of text sent by your web browser by a website you visit. A cookie file is stored in your web browser and allows the Service or a third-party to recognize you and make your next visit easier and the Service more useful to you.
When you use and access the Service, we may place a number of cookies files in your web browser.
We use both session and persistent cookies on the Service and we use different types of cookies to run the Service:
In addition to our own cookies, we may also use various third-parties cookies to report usage statistics of the Service, deliver advertisements on and through the Service, and so on.
What are your choices regarding cookies
Please note, however, that if you delete cookies or refuse to accept them, you might not be able to use all of the features we offer, you may not be able to store your preferences, and some of our pages might not display properly.
Where can your find more information about cookies
You can learn more about cookies and the following third-party websites: