In my source file, I have a lookup field that needs to be validated against the ID of the lookup table in the database.
The source lookup field may contain nulls since the destination table field has nullable property set.
1. How do I validate my source lookup field for only the not null data?
2. If the source look up field value does not match with the data in the database lookup table, how do I assign a default value to the source lookup field?