Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.
Which solution should a data architect use to ensure successful data migrations?
- A.Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
- B.Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
- C.Export legacy data into CSV files and leverage data loader to load data into Salesforce.
- D.Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.