Import Data from Excel

Question 1

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

Answer 1

– Load Data

Question 2

What are the steps for importing

data using an import set?

Answer 2

– Load the data
– Create a transform map
– Transform the data
– Clean up the import table

Question 3

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

Answer 3

– Coalesce

Question 4

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

Answer 4

– Transform Map