Interview questions: Data Migration

Question 1

1. Briefly describe Data Import Wizard?

Answer 1

Data Import Wizard is a data importing tool that can be used for Standard and Custom
Objects from the Salesforce interface, and can import up to 50,000 records at once.

Question 2

2. Describe Data Loader?

Answer 2

Data Loader is a tool or Application used in salesforce to import and export bulk data.
ThroughApex Data Loader we are able to Update, Insert, Delete, Upsert, Export and
Export All. Each operation will be different from each other. Supports loading up to 5
million record rows

Question 3

3. Describe Data Export?

Answer 3

The data is exported as a set of comma-separated values (CSV) files. Data export tools
provide a convenient way to obtain a copy of your Salesforce data, either for backup or
for importing into a different system.

Question 4

4. Which file type is used when exporting and importing data in SF?

Answer 4

comma-separated values (CSV) files

Question 5

5. What is Dataloader.io?

Answer 5

Dataloader.io is an installation-free SaaS service that can be accessed with a Web
browser, capable of performing many operations such as exporting data from
Salesforce, importing data or deleting data, and unlimited data transfer depending on
the license.

Question 6

6. What to check before Data Import?

Answer 6

• The file to which the data will be transferred must be in CVS
  format.
• Data field names in the file and data field titles in Salesforce must
  be the same.
• Make sure the fields in the file, such as Date, are written in the
  correct format
• In the file, make sure that the corresponding Piclist values in the
  Salesforce system are compatible with each other.
• Validation Rules and other Automated automations should be
  controlled.