Can't Transform the data imported by "Test Load 20 records" from the Data SourceSummaryThe "Load All Records" is a well designed feature to import data into the instance using two steps: First step is loadingSecond step is transforming. It is crafted to a very high specification, where the loading happens on the Data Sources while the transforming happens on the Transformation maps. Each execution is controlled by an Import set that displays the history of the data imported. However, On the Data Source, the Test Load 20 Records feature can lead to confusion. If you click "Test Load 20 Records" as opposed to "Load All Records" it won't actually transform your data. Instead, it will retrieve the data for the first 20 records, as opposed to all. However, this feature is not useless. There are some cases where you would want to Test Load the first 20 records of your data. Once on the data source, Test Load 20 Records will allow you to: To create the import set table if it does not exist. The import set table is the table where the data is loaded.To create the transformation map and map the source field names once the "import set table" exist. The feature itself will not create the transformation; however, it will create the import set table if it does not exist, allowing the system to retrieve the field names. The main use case of the Test Load 20 Records feature is to validate that the load works correctly. Use "Test Load 20 Records" to validate if the data load works correctly and you have set the correct configuration (e.g. passwords) There are a few things that Test Load 20 Records DOES NOT permit. You will not be able to transform the 20 records loaded. Data loaded with this test will not be part of the transformation.You will not be able to automatically import and transform. Data is only loaded. It's NOT transformed. To automatically import and transform, you need to create a scheduled job to load the data, which will also transform it. To manually transform your data, go the transformation map, then click "Transform'" "Test Load 20 Records" is DOES NOT transform the data after it gets imported. Test Load 20 Records vs. Load All Records When loading data and transforming it, it is important to consider the use cases for both testing and loading the 20 records, or going all out and committing to loading all records. If your goal is just to validate and test that the data works correctly, "Test Load 20 Records" is the way to go. If you want to go through the full process and import and transform the data, use "Load All Records."