importing data to a target table that has a reference field

[ServNowDev]

I have a target table named Vacations and another table named Customer, I would like to have data transformed into the vacations table where it will have a vacations field with a number of each vacation, sometimes there can be some vacations with the same vacation number if there are multiple flights involved for eg below. I want to the Customer table to have all of the information of the vacations traveler. so i have related list in the Customer table that will list all alike vacation numbers. This means i would need a Customer table created when new vacations records are created. also a reference field to the customer table. Issue is how can I import data to a vacations table with a reference field if no records exist yet? is this possible?

Vacation Number   Airport Arrival   Arrival Date

VAC0001              JFK                      9/16/2023

VAC0001              BWI                    9/25/2023

[palanikumar]

Hi,

While mapping reference field in Order table set "Referenced Value Field" to u_order_id (field of order id in the referenced table)

Thank you,

Palani

[ServNowDev]

This will give error messages during the transform as there is no record of a reference as yet , new values will enter the system that does not have a record to the reference field and will need to be created if not found