Data Migration Approach: Data Mapping, Extraction & Transformation – 2

navigate to this site Data Migration Approach: Data Mapping, Extraction & Transformation – 2 SQL server database for running the validation rules:

When loading source data into SQL Server is to have Staging tables to run various scripts. ie to check for integers in Varchar columns / text in Integer column etc…, check the maximum entry in a column to avoid truncation errors. Then we can factor in Data Type lengths and data Types themselves making sure we are covering all errors with dataloads.

We should all sit together with a few examples so we get all the processes in the right order and that we understand them. Cut Down files

We need to know what tables & fields needs to be loaded in Horizon and NAV for intended functionality to work.

o Referring to the “NAV data migration templates”, we know what tables needs to be loaded for most of the business objects, but not for Open AR/AP Invoices, etc.,
 We need inputs from SI indicating the tables that needs to be loaded for Open transactions.
• Horizon
o We have data dictionary, but we don’t know what tables needs to be populated for each business object
E.g. if we need to load more than one table and related data dependencies
o We need inputs from Horizon indicating the tables that needs to be loaded for each business object
Then we can finalize the mapping templates and identify the missing fields/gaps
• Identifying Gaps / Missing Columns
o Once we have the above information, we will be in a better position to ask client to include the missing columns/info.

internet dating sites someone who wants to talk explicitly Summary

There needs to be  data migration strategy document detailing the approach of how the data will be staged and the transformations/validations that needs to be applied and run before data is loaded into Horizon & NAV.

In summary, we need the following process documents in place:
1. Data Migration Requirements & Strategy document covering –
a. Requirements Summary of all business objects
b. Data migration approach – Source files, Staging, Transformations/Validations, Loading
c. Reconciliation processes
2. Mapping Functional Design Document – one for each business object
3. Mapping Template – one for each business object for each Target

And the Mapping functional design document & Mapping template needs to be created for each business object by respective owner, thus will be useful if an object is assigned to other resource in future, as a reference to start with.


Leave a Reply

Your email address will not be published. Required fields are marked *