As the data of the clients that are only of Orange and Los Angeles counties should be loaded into the database, a reference file is needed in order to filter only Orange and Los Angeles clients. The file contains the following city-to-county mappings.
City;County
GRANADA HILLS;Los Angeles
MISSION HILLS;Los Angeles
ALISO VIEJO;Orange
ANAHEIM;Orange
ARCADIA;Los AngelesThe reference file in this Job is named LosAngelesandOrangeCounties.txt.