Notifications

828 views

Importing data using Load All Records or Test Load 20 Records 

 

Objective
The objective of this note is to explain the difference of importing records from data sources using the options Load All Records and Test Load 20 Records.

 

Procedure
Load All Records and Test Load 20 Records are UI actions located on the related links for a particular data source.

Data sources are located at System Import Sets > Administration > Data Sources.

The usage of these following UI actions is similar, but the use case for each is quite different. 

Load All Records

This UI action is used when the data has already being validated and you are ready to transform the data using the Transform option to import the data into the target table. This action sets the internal state of the import to Loaded. Note that the Transform option to run the transformation maps will only process imports with this state.

Test Load 20 Records

This UI action is generally used to validate the records that you want to import without the initial intention of running a transformation map to the target table. This action sets the internal state of the import to Load, therefore the transformation map is skipped.

If needed, the Test 20 Records UI action allows you to ultimately run the Transform option, but a Reprocess action is required.

Reprocess

This UI action changes the internal state of the test import from Load to Loaded. As a result, you can now run the Transform option for the subset of 20 records"test loaded from the import set.

  

Conclusion

The action Load All Records is used when the data has already being validated and is ready to be transformed into the target table.

Skipping the transformation map is the standard behavior for the action Test Load 20 Records. This action is recommended for validation purposes, however, the transform and import can be forced for the 20 records imported during the test load by using the Reprocess action.

 

Related links

Article Information

Last Updated:2016-09-20 09:34:16
Published:2016-02-17