CSA · Question #303
What are the steps for importing data using an import set?
The correct answer is A. Create Import Set; Create transform map; Transform data; Clean up import table. The correct sequence for importing data via an import set involves creating the import set, creating a transform map, transforming the data, and then cleaning up the import table.
Question
What are the steps for importing data using an import set?
Options
- ACreate Import Set; Create transform map; Transform data; Clean up import table
- BCreate a Transform Map, Load Data, Transform Data, Run Transform Map Script
- CIdentify source; Import transform map; Run transformer; Verify import
- DSelect source file; Run AutoMap; Transform data; Clean up target table
How the community answered
(66 responses)- A88% (58)
- B2% (1)
- C6% (4)
- D5% (3)
Why each option
The correct sequence for importing data via an import set involves creating the import set, creating a transform map, transforming the data, and then cleaning up the import table.
The standard process for importing data using an import set involves first loading the data into a staging table (creating an import set), then defining the mapping rules to the target table via a transform map, executing the transform to move the data, and finally, cleaning up the temporary import table. This systematic approach ensures controlled and accurate data migration.
'Run Transform Map Script' is not a distinct, general step in the primary import process, and 'Load Data' typically precedes 'Create a Transform Map'.
This option uses non-standard terminology for several steps, such as 'Import transform map' and 'Run transformer'.
'Run AutoMap' is an automated feature, not a required manual step, and 'Clean up target table' is generally not part of the standard import process cleanup which focuses on the import table.
Concept tested: Data import set process steps
Source: https://docs.servicenow.com/bundle/utah-integrate-applications/page/administer/import-sets/concept/c_ImportSets.html
Topics
Community Discussion
No community discussion yet for this question.