Lookup tables, which contain derived data, are loaded during initialization.
The lookup column must be convertible into the RDS type of the lookup data. The lookup return column datatype must be convertible into the datatype of the destination column of the target table.
The data transfer facility for derived data does not attempt to automatically maintain dependencies across tables. Developers, or Ops Console administrators, must define transfer rules to accommodate transfer of any dependent data.