Data is being inserted with reference columns as empty in ETL<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Reference data mapping in ETL is not properly inserting the data in the target table even though mapping is correct. This is due to the fact that when reference data is selected to sync from provider, the reference type's table's display value is synced instead of Sys Id. This is because it is not guaranteed to have the same sysId maintained across instances, as sysIds can vary between different systems or instances. ETL expects SysId for reference data lookup, and since FDS syncs display value, ETL cannot find the target reference data during lookup and leaves the reference field empty, resulting in incomplete or inaccurate data in the target table. Follow the below steps for the work around: 1. Navigate to ETL and open the appropriate definition 2. Navigate to Step 2 "Preview and Prepare data" 3. Click on "Table lookup" to create a new transform and provide the following details. Select the following criteria: For example, to enable the ETL to perform a lookup on the "Company" table, select the source column that contains the display value, such as the name of the company, and select the corresponding display field on the target lookup table ("Company" -> Name). Alternatively, multiple columns can be used to filter the records further and refine the lookup results. Finally, select the output values as "Sys Id" to ensure that the ETL can correctly identify and map the reference data. It is essential to mention this transform column name, as it will need to be added in the column mapping in Step 3 during the mapping of classes to ensure accurate data transformation and integration. 4. Once the table lookup transform is created, the transformed output column can be seen on the preview data which should be mapped to the reference column during the mapping of source columns to target columns. 5. Run the integration after the mapping is done to see the data being selected in the reference types.