Contents
- 1 How would you validate a data migration from one database to another?
- 2 What is data migration means in Salesforce?
- 3 What is data Loader in Salesforce?
- 4 When do you need to do data migration in Salesforce?
- 5 How are data transformation tables used in Salesforce?
- 6 What’s the best way to do data migration?
How would you validate a data migration from one database to another?
Here are 8 steps to follow in the data migration process.
- Define the Scope.
- Study requirements, Business Rules and Mapping Document.
- Dependencies and Interactions.
- Create Test Cases and Queries to Verify the Data.
- Execute Test Cases.
- Compare the Results.
- Non-Functional Testing.
- Functional Application Test.
What is data migration means in Salesforce?
Salesforce data migration is defined as the process of moving Salesforce data to other platforms where required. The migration is an opportunity to cleanse the data and the data should demonstrate the following characteristics: Timeliness- Data should be available when you need it.
What is the process of data validation testing?
Data Validation testing is a process that allows the user to check that the provided data, they deal with, is valid or complete. Data Validation Testing responsible for validating data and databases successfully through any needed transformations without loss.
What is data Loader in Salesforce?
A Salesforce data loader is a universal tool used for bulk importing and exporting of data. It provides a user-friendly UI or command line access. When importing records, a data loader will read, extract, and load information from CSV files or from a database.
When do you need to do data migration in Salesforce?
Salesforce data migration is the very first thing you must do before go-live in order to bring all the existing data from your legacy system into the Salesforce Cloud without losing any of it. Migration is a one-time activity; once the data is loaded into the Salesforce org, the migration task is complete.
What is the purpose of integration testing in Salesforce?
Functional/Integration Testing: Data Integrity Validation: Validate that contacts and opportunities have been associated with the correct accounts. Validate that that all duplicates and invalid data have been eliminated. Workflow Validation: Validate that all new workflow, assignment, approval rules and email notifications are working correctly.
How are data transformation tables used in Salesforce?
In this case Salesforce data transformation tables are used to make the needed data conversions. Validate the source and target system connections from the migration platform. Test tool configuration against the migration specification to verify that a migration specification’s mappings are complete and accurate.
What’s the best way to do data migration?
Create and follow a data migration workbook throughout the scope of migration. This is a consolidated workbook that holds the data mapping for each object involved in the process. A single template with multiple tabs (one each for each mapping object) including a DM checklist and storage requirements.