The selection set logic that is in place for the ETL matches what I get from a manual selection - except 9 additional records were captured in the Append_Failure1_RESTBMP_p_to_RESTBMP feature class. Tracing these 9 back, the associated source.SW_TRACKING records are related to a source.BMP_POIS record. The selection set for 1B should exclude all records associated to a source.BMP_POIS - this is also the case for set 1A, and it appears to be working there.
The 9 symptomatic records are SW_TRACKING_NUM:
BMP001642
BMP001831
BMP002277
BMP002397
BMP002589
BMP002660
BMP003003
BMP003867
BMP004670
The selection set logic that is in place for the ETL matches what I get from a manual selection - except 9 additional records were captured in the Append_Failure1_RESTBMP_p_to_RESTBMP feature class. Tracing these 9 back, the associated source.SW_TRACKING records are related to a source.BMP_POIS record. The selection set for 1B should exclude all records associated to a source.BMP_POIS - this is also the case for set 1A, and it appears to be working there.
The 9 symptomatic records are SW_TRACKING_NUM: BMP001642 BMP001831 BMP002277 BMP002397 BMP002589 BMP002660 BMP003003 BMP003867 BMP004670