Import Data from Excel

What are the steps for importing data using an import set?

1.Load the data 2.Create a transform map 3.Transform the data 4.Clean up the import table

Which option allows you to update existing target table records when importing data from an import set?

Coalesce

Which module is used as the first step for importing data?

Load Data

Which tool is used to determine relationships between fields in an import set and an existing table?

Transform map